AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N635FTFlorida Institute Of Technology · Melbourne, FLN635KCCavorite Aviation LLC · West Jordan, UTN635SCSpartan Education LLC · Tulsa, OKN635TBEnvy Aviation LLC · Tampa, FLN635WWByrd Creek Aviation LLC · Winter Haven, FLN635XXVelox Aviation Inc · Pensacola, FLN63609Filtenborg Daniel · Shelbyville, MIN6360JAgl High Sky LLC · Midland, MIN6360PRoyal Scott A · Richmond, MEN63612St Charles Flying Service Inc · Portage Des Sioux, MON6361JPenne Jill K · Cedar Rapids, IAN6361LDauernheim John M · Henderson, NVN6361PSharp Edwina B · Kent, WAN63628Black Hills Airplanes LLC · Rapid City, SDN6362NGoodwin David C · Boulder, WYN6362QHanley Clint · Edgewood, NMN6362RHighsmith Ronald R · Lake Havasu City, AZN6362USundowner Holdings LLC · Mayflower, ARN6363J6363j LLC · Beech Bluff, TNN6363QLawrence John C · Belle Chasse, LAN6363UTf Skies LLC · Mount Pleasant, TXN6363WKvidera N6363w LLC · Webster, WIN6364DSuburban Aircraft Leasing And Sales LLC · Sylvania, OHN6364JVenture West LLC · Mesa, AZN6364PAdamczyk Douglas · Surprise, AZN6364RWilliams Jacqueline · Mint Hill, NCN63659Droege Robert Michael · Saratoga Springs, NYN6365CWingsleasing LLC · Wichita, KSN6365FRindo David J · Lowell, MAN6365JLeverton James F · Cannon Falls, MNN6365NSouth Dakota State University · Brookings, SDN6365RPrentice Timothy W · Kingman, AZN6365WGaglianello Mark · Magnolia, NJN63663Lake Aviation LLC · Murfreesboro, TNN6366CHalpin Aviation Inc · Eden Prairie, MNN6366FDerose Joseph F · Salt Springs, FLN6366JTaff Jehu Thomas · Greenville, NCN6366LFritel Construction Co Inc · Stanley, NDN6366MWaymire Thorne L · Big Bear Lake, CAN6366NCarlson Eric S · Kodiak, AKN6366PN6298p Inc · Okeechobee, FLN6366QLibre Air LLC · Norfolk, VAN6366RBatta Krishnakanth · Mountain House, CAN6366TBaclich Brett J · Dubuque, IAN6367Makino Kazuya · Fountain Valley, CAN6367CWings High Aviation LLC · Fayetteville, NCN6367LM&S Aero LLC · Wilmington, DEN6367QCc Aviation Inc · Tracy, CAN63681American Patrols Inc · Midland, TXN6368JPrins Damon · Angels Camp, CA
Back to AD 90-04-06 R1