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.
N6WADue North Aviation LLC · League City, TXN6WNDart Gregory G · Mayville, NYN6WRCueva Arturo A · Los Angeles, CAN6XAFlying Farmers LLC · Dalhart, TXN6XCNorthstar Aerospray Inc · Clara City, MNN6XLCrowe Donald L · Mcallen, TXN6XQAccuracy 1st · Canadian, TXN6YEExperimental Aircraft Association Inc · Oshkosh, WIN6YGArcher Project Management LLC · Forney, TXN6YLHolman Leasing LLC · Anchorage, AKN6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKN6YQBeek Dudley E · Miami, FLN6YTCassinelli Steven W · Oceanside, ORN6ZHarris Hayden H · Chelsea, MIN6ZHPetranek Diana C · Albion, NYN6ZPAmerican Patrols Inc · Midland, TXN6ZTLewis Eddy L · Cortez, CON700Dailey Jeffrey D · Weirton, WVN70000Carson Mark L Trustee · Northfield, MNN70004Gbl Aviation LLC · Laurel, MSN7000RJilek Peter Andrew · River Falls, WIN7000WIndy Air Sales LLC · Anderson, INN7000XWalsh Peter F · Walpole, MAN7000YSlowpoke Air LLC · Palm Harbor, FLN70012Military Aircraft Restoration Corp · Anaheim, CAN7001DOwens Eldon J · Arimo, IDN7001KJersey Devil Dusters LLC · Southampton, NJN7001WBrinc LLC · Lancaster, PAN7002KHeinze Gregory L · Little Rock, ARN7002ZKistler Michael J · Wasilla, AKN70032Alpha Wings Inc · Willoughby, OHN7003BByrd Kyle E · Unionville, MON7003PAviation Career Enrichment Inc · Atlanta, GAN70046Zane Newton F · Rllng Hls Est, CAN7004FSouthern Vector Aerospace LLC · Huntsville, ALN7004GMcgreen John R · Albany, NYN7004REasley Leroy · Novelty, MOFirst renewal noticeN7004WLettsome Nesco · Beltsville, MDN7005Paragon Airplane Leasing Co · Fort Myers, FLN70052Hastings Heidi · Wasilla, AKN70057Hoffpauir Amanda Eve · Waller, TXN7005GHamilton Peter D · Bear, DEN7005QCentral Arkansas Flying Club Inc · Bryant, ARN7006QToney Edward L · Hampton, GAN70075Kennel Isaac John · Salt Lake City, UTN7007JKeltner Kody M · Meadville, PAN7007KJackson Gary Lynn · Simms, TXN7007TAnderson Karen Lynn · Wasilla, AKN7007WBiros Timothy D · Nya, MNN7007XConcho Aviation LLC · Sterling City, TX
Back to AD 90-04-06 R1