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.
N54025Nash Joseph R · Fairbanks, AKN5402EOsprey Holding Company LLC · Foley, ALN5402FMorgan Kristopher Lm · Crowley, TXN5402HBast Fred D · Fairbanks, AKN5402LChomchird Attaporn J · Centreville, VAN5402RBarsto Aviation Inc · Wilmington, DEN5402SCharlie Ten Inc · Quakertown, PAN54031Mlr Adventures Inc · Wilmington, DEN54036Missions Unlimited Of Oregon Inc DBA · Harrah, OKN5403FAcs Wings LLC · Deerfield Beach, FLN5403HWings Over Texas Holdings LLC · Denton, TXN5403VL & R Consulting LLC · Las Vegas, NVN54041Bowen John E · Ocala, FLN54048Hodge Flight Services LLC · Pittsburgh, CAN54049Pittinger Mitchell J · Reisterstown, MDN5404BRichmor Aviation Inc · Hudson, NYN5404HPool Hap · Vail, CON5404LRegistered aircraftN5404PClough Robert A · Grass Lake, MIN5405BNatkat Aviation Services LLC · Finleyville, PAN5405LScalia Dennis · Westlake, LAN5405MToozer Air LLC · Ormond Beach, FLN54067St Pete Aviation Services LLC · Saint Petersburg, FLN5406KNewcom Bradly C · Hanson, KYN5406LLone Roger D · Prosperity, SCN5406WScott Jeffrey E · Connersville, INN5406ZRains Kenneth W Jr · Lebanon, TNFirst renewal noticeN54073Center O Flying Club · Tumwater, WAN54079Christiansen Aviation LLC · Wilmington, DEN5407FFly Quest Aviation LLC · La Verne, CAN5407HPye Jennifer · Roanoke, TXN5407LStech Stuart · Fredericksburg, TXN5407WThird Step 6 LLC · Gilbert, AZN5408ECutbirth Henry R · Monahans, TXN5408HSchmidt Kelly D · Lake Elmo, MNN5408RRegistration Pending · Brookland, ARRegistration pendingN5408USanders Aviation Inc · Jasper, ALN5408WTriple M&W LLC · Bloomfield, IAN5408YHargreaves William A · Lovettsville, VAN54093Kamenev Alexey · Hinsdale, ILN54094Mustang Sally Aviation LLC · Camden, SCN5409FBlackwolfden Aviation LLC · Belgrade, MTN5409JKelley Aircraft LLC · Weyers Cave, VAN5409LBarnhardt Robin J · Eleva, WIN5409MJackson David B · Mansfield, TXN5409PReinaudi Gael · New York, NYN5409RMclane Tucker · Newton, MAN540ACChristians Ricky P · Appleton, WIN540BDBrajer Animo LLC · Ostrander, OHN540CWCentral Washington University · Ellensburg, WA
Back to AD 90-04-06 R1