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.
N4427ZLanders Russell R · Tok, AKN44285Chisolm Joe B · Marble Falls, TXN4428HBowman Billy G · Gold Hill, NCN4428JJohnson Clyde L · Live Oak, FLN4428MMittelstadt Garret A · Oakfield, WIN4428TGauvin Daniel G · Newport, VTN4428XLeopold Nathan · Fond Du Lac, WIN4428ZRegistered aircraftN44290Fly With US LLC · Cantonment, FLN4429APrillwitz Nolan D · Appleton, WIN4429PRegistration Pending · Kenai, AKRegistration pendingN4429QDyberg Mike DBA · Mount Vernon, WAN4429RMacoupin Flyers Inc · Hettick, ILN4429ZAerial Crop Care Co · Hebron, NDN442AAbrams Gary L · Tucson, AZN442BBMcdougall Michael D · Caldwell, IDN442BJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN442BSNext Level Capital LLC · Spring, TXN442CACoast Flight Training And Management Inc · Dallas, TXN442CMAnderson Charles M Jr · Snohomish, WAN442DBRegistered aircraftN442DCMurray Jeffrey H · Saranac Lake, NYN442DMYoung Lawrence N · Poplar Grove, ARN442FAJackson Paul Douglas · Victoria, VAN442HBAirborne LLC · Wilmington, DEN442HGGeorgia Aviation Authority · Eastman, GAN442KLLedwith Kenneth E · Lincoln, CAN442LCKnudtson Kirk · Kasson, MNN442MKG&M Aircraft Inc · Wheat Ridge, CON442MLOrlowski Micheal A · Gold Hill, NCN442PABird Acquisition LLC · Phoenix, AZN442RJHeymach Robert F · Holbrook, NYN442RMRocky Mountain College · Billings, MTN442SAG & M Aircraft Inc · Wheat Ridge, CON442TFerreira James M · Dixon, CAN442TCCrawford Thomas A · Hawthorne, FLN442TWMclaws Craig J · Sheridan, WYN442WBAllen Lanny D · Indianapolis, INFirst renewal noticeN442WRWhite Ryan R · Polk City, IAN4430RDunder Neil DBA · Cicero, INN4430ULfm Aviation LLC · Bozeman, MTN4430ZLorimor Thomas T · Sidney, IAN4431J & J Aircraft Holdings LLC · Vonore, TNN44314Yates Cecil R · Westminster, CAN44318Trinity Air Service Inc · Klamath Falls, ORN4431AResetarits Matthew · West Seneca, NYN4431QGraham Huber L · Gulf Breeze, FLN4431RRaritan Valley Flying School · Princeton, NJN4431TTaylor Timothy · Chandler, INN44326Mccaslin Dale Alan Trustee · Holt, MO
Back to AD 90-04-06 R1