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.
N4587NPlane Fun Inc Tr Trustee · Snellville, GAN4587TStory'S Aviation Services LLC · Webster, FLN4588Smithenry Eric J · Newton, ILN4588JSierra Hotel Fliers LLC · Lexington Park, MDN4588LLewis Robert J · Carthage, NCN4588TLeavitt James W · North Ferrisburgh, VTN4588XMaus Steven M · New Braunfels, TXN4588ZEta Of Missouri Inc · Lone Jack, MON4589JArthurs Nathanael L · Indiana, PAN4589WBort Productions Inc · Covina, CAN4589XSek LLC · Concordia, MON458AArcher Aero LLC · Wilmington, DEN458ARPiper Aircraft Inc · Vero Beach, FLN458BHEdwards Thomas M · New Tazewell, TNN458CMUniversity Of Central Missouri · Warrensburg, MON458DFontelieu James · Maplewood, NJN458FLGentle Mike · Pendergrass, GAN458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKN458LBBeedy Lyle G · Derby, KSN458RVRussell Steven J · Wilmington, ILN458SPChristiansen Aviation LLC · Wilmington, DEN458WTls Aviation LLC · Smyrna, TNN4590AEllis Darry Lynn · Wasilla, AKN4590BFulltron Aviation LLC · Springfield, MON4590FDavid Badaczewski · Gettysburg, PAN4590JEpic Aviation Inc · New Smyma Beach, FLN4590PWings Over Texas Holdings LLC · Denton, TXN4590ROzar Abdurrahman · Virginia Beach, VAN4590TOdonald John C · Greenville, MIN4590WBfi Financial Alliances Limited LLC · Cave Creek, AZN4590ZSpeck Daniel N · Waverly, NYN45915Southern Aircraft Consultancy Inc Trustee · Casper, WYN4591ACollins William A · Tillar, ARN4591HCampbell James R · Bennett, CON4591RJohnson Robert B · Wichita, KSN4591WRojas Franklyn N · Ocala, FLN4591ZColt Flying Club LLC · Lebanon, PAN45928Cohan Thomas A · Sparks, NVN4593ABvm LLC · Stonington, CTN4593FSterling Flight Training LLC · Jacksonville, FLN4593HFriebel Mark A · Shelby, OHN4593VFranklin Eric J · Anchorage, AKN4593XClubs 2 LLC · Calabasas, CAN45941G&M Aircraft Inc · Wheat Ridge, CON4594F181 Corporation · Charlotte, NCN4594NChisum Brian J · Valley View, TXN4594REkblad Carl Allyn · New Port Richey, FLN4594XAdventure Ventures LLC · Salem, CTN4594ZRichard Waldren LLC · Newberg, ORN4595FSchroeder Herbert D · Plano, TX
Back to AD 90-04-06 R1