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.
N416FPUtah State University · Logan, UTN416HPKt7 Aviation LLC · Katy, TXN416JLCondren Ryan · Sunnyvale, TXN416PASkywest Leasing Inc · St George, UTN416RBWhite Jared William · Grass Valley, CAN416RHMckamey Robert S · Tullahoma, TNN416RKWindyfork LLC · Black Mountain, NCN416RPMiller Aircraft Services Inc · Crookston, MNN416RVRegistered aircraftN416SDTailwheel Adventures LLC · Celebration, FLN416SSChristie Ian A H · Limon, CON416WTHigh Desert Flight Instruction LLC · Albuquerque, NMN417Mckinney Lloyd M · Boise, IDN41700Craven Mark C · Salome, AZN41703Sweeny Daniel L · Parrish, FLN4170JMoscrip Mark D · La Vernia, TXN4170LOsborn Allan R Trustee · Springfield, VAN4170PIfa Aviation Inc · Wilmington, DEN4170TVwfusco Aircraft Management LLC · Stratford, CTN4170YCraig Jerome A III · Plantation, FLN41714Nunn Ethan Edwin · Melba, IDN41718Baker Thomas David · Noble, ILN4171HHanson Zane · Danville, INN4171XGailing Jessica L · Costa Mesa, CAN41723Sale Reported · Greensboro, NCSale reportedN4172DChristiansen Aviation LLC · Wilmington, DEN4172HMckinney James V · Yucaipa, CAN4172JAscension Enterprises Inc · Saint Augustine, FLN4172MWeber Keith T · Rubicon, WIN4172YColonels Flying Club · Princeton, MNN4172ZMathew Priya Trustee · Utica, NYN41731Novak Michael · Chicago, ILN41738Dadson Aviation LLC · Lowell, INN41739Triple Nickel Inc · Muleshoe, TXN4173DCw Flyers Ltd · Wilmington, DEN4173MReints Rydell J · Wasilla, AKN4173ZHelmericks Aaron W · Wasilla, AKN4174JNorth Creek Flying Club Inc · Continental, OHFirst renewal noticeN4174TAverett University · Danville, VAN41756N41756 LLC · Upper Marlboro, MDN4175HWhitford John A II · Weedsport, NYN41764Bellator Air LLC · Arden Hills, MNN41766Schneider Steven M · Evansville, INN41774Higher Plane Inc · Ft Lauderdale, FLN4177LBird Acquisition LLC · Phoenix, AZN4177NMankato Aviation Service Inc · Mankato, MNN4177PMoran John B · West Roxbury, MAN4177ZCruiser LLC · Munger, MIN41785On The Ball Aviation LLC · Sloughhouse, CAN41789Flickinger Thomas F · Madison, WI
Back to AD 90-04-06 R1