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.
N399DPThomason Charles P · Columbus, GAN399ESBray Aviation LLC · Calera, OKN399HPPresley Denny · Tracy, CAN399JPL&M Aircraft Inc · Rome, GAN399JTGiannoulas Chris Paul · Federal Way, WAN399MJohnsey Stanford Wallace · Kingsville, TXN399MACavorite Aviaton LLC · West Jordan, UTN399RMEyles Edwin W Jr · Butler, PAN399RSRegistered aircraftN399SBBuchanan Sam C · Athens, ALN399TCTexas State Technical College · Waco, TXN399XHlavin Mark S Trustee · Lakewood Ranch, FLN39ACCoyle Whitney J · Edgewater, FLN39AFTuskegee Airmen National Historical Museum Inc · Detroit, MIN39AHCapital Aircraft LLC · Juneau, AKN39ALMcentire David J · Bainbridge, INN39BPEmerald City Aircraft Leasing Inc · Port Orchard, WAN39BRSystems Research Corp · Wilmington, DEN39CFFedrigo John A · Moneta, VAN39CTRotramel Paul D · Hardinsburg, KYN39CWWindham Charles R · Rogersville, TNN39DBKwasinski Mark W · Kalamazoo, MIN39DCCruson Dale E · Ontario, ORN39DRLehigh Valley Flying Club Inc · Lehigh Valley, PAN39DUYokoo Kureha · Petaluma, CAN39ECSmith Adria A · Kingwood, TXN39ESHowell Jeff D · Payette, IDN39FZLongley Charles A · Nome, AKN39GMonteleone Gene R · Mount Vernon, TXN39GCWilliams Jeffrey D · Florence, ALN39GDNovember Sierra Romeo LLC · Byron Center, MIN39GHApaka Lee K · Fairfield, CAN39GMBacon Gregory A · Prairie Home, MON39GTAshwill Gregory L Trustee · Overgaard, AZN39HBBartle Henson P · Independence, ORN39HUCallaghan Jonathan D · Driggs, IDN39HYReed Hollow Aviation LLC · Franktown, CON39JMJads Aviation LLC · Rowlett, TXN39JPCabebe Brian M · Mesa, AZN39KWFier William J · Austin, TXN39KYYang Chi · Lafayette, CON39LDMau Thomas E · Kenmare, NDN39LTGeorgia Forestry Commission · Macon, GAN39MRGraupman Gerald · Chicago, ILN39NDTerwillegar Charles E · Renton, WAN39NSMacair Inc · Corvallis, ORN39RFHughes Todd R · Euless, TXN39RLAdams Nathan M · Edgewater, FLN39RSRoberts Terrance M · Fayetteville, ARN39SDMbm Leasing LLC · Jacksonville, NC
Back to AD 90-04-06 R1