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.
N86483Eaa Aviation Foundation Inc · Oshkosh, WIN8648CHouse Justin W · Uriah, ALN8648VBeachy Phil R · Bonners Ferry, IDN8648YChuss Edward · Metamora, MIN8649Dudley Benjamin H · Wasilla, AKN8649DGho Michael M · Fairbanks, AKN8649NManchester Thomas P · Wilmington, DEN864EBudner Jeffrey B · Rio Vista, CAN864GBenson Brad · Mamou, LAN864JBouchard Cary T · Washburn, WIN864MSwingle Howard D · Blacksburg, VAN864PUTrustees Of Purdue University · West Lafayette, INN864TWTailwinds Academy Of Aviation · Philadelphia, PAN865Birge Stuart M · Charlotte, NCN8650CMalan Desiree · Anchorage, AKN8650EGotta Fly LLC · Manitou Springs, CON8650NAllen Flight Service LLC · Laredo, TXN8651CDoby Julian · Graham, NCN8651ESchoen Michael · Lakeville, MNN8653Rempel Warren K · Longmont, CON8653VLarson Paul E · Palmer, AKN8653YMorris Equipment LLC · Yuma, AZN8655CBraun Ronald J · Wasilla, AKN8656GRut-Roh Flyers LLC · Greer, SCN86571Houck Steven E · Fairbanks, AKFirst renewal noticeN86573Phoenix Aviation Services Inc · Miami, FLN86574Kern Hunter S · Anchorage, AKN86576Pirkle Anthony E · Theodore, ALN86578Halpin Aviation · Eden Prairie, MNN86579Youngs William D Jr · Moravia, NYN8657DParks John T · Ripon, WIN8657VFrahm Michael T · Willow, AKN86582Sale Reported · Oxford, IASale reportedN86583Merrell Glen R · Eatonton, GAN86585Birchler Judy A · Indianapolis, INN86588Roberts Todd L · Friday Harbor, WAN86591River Aviation Consulting LLC · Lake Havasu City, AZN86592Landry Matthew A · Soldotna, AKN86594Beadle Scott · Fort Worth, TXN86595Coker Janie K · Tyler, TXN8659CBraddock Randall C · Syracuse, KSN8659EKuehn Ricky A · Mesa, AZN865CPAmr Holdings LLC · Kalispell, MTN865DMMacniven Donald B · Colorado Springs, CON865ESHangar Ak LLC · Sterling, AKN865GAtp Aircraft 9 LLC · Wilmington, DEN865KKDewalt Rodney P · Fort Worth, TXN865LJones Donald · Knoxville, TNN865LTHogan David A · La Crosse, WIN865PUTrustees Of Purdue University · West Lafayette, IN
Back to AD 90-04-06 R1