AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N26EAThweatt Andrew C · Riverside, CAN26EDTurboprop Co LLC · Collegedale, TNN26EHEvans Robert · Phillips, NEN26EPErid Air LLC · Blackfoot, IDN26ERGreen Hornet Aviation LLC · Washington, DCN26EVN26ev LLC · Pine, CON26EXHolmes Arnold R · Port Orange, FLN26FBBluhm Raymond M · Waxhaw, NCN26FCRwr Air Inc · Tok, AKN26FDAbnc Air LLC · Wellington, FLN26FFFastfun LLC · Fort Myers, FLN26FPTate Zachary W · Cypress, TXN26FTDelaware Aircraft Trust LLC Trustee · New Castle, DEN26GACrosswind Leasing LLC · Prescott, AZN26GBLunt Christopher J · Marco Island, FLN26GKSparkjoy Air LLC · Boulder, CON26GRLakeside Capital Holdings LLC · Green Cove Springs, FLN26HAEpsilon Equity Partners LLC · Houston, TXN26HBBk Outlaws Inc · Myrtle Beach, SCN26HMKrause Jason · Glendale, AZN26HSCole Gregory B DBA · Santa Cruz, CAN26HUOks LLC · Apex, NCN26HVHotel Victor LLC · Bend, ORN26HYFocus Air LLC · Wilmington, DEN26JGMckay Brian P · Linden, MIN26JSWarrick Douglas R · Corvallis, ORN26JTBohning Aviation LLC · Ponchatoula, LAN26KGarrett Robert A · Dallas, GAN26KAOliver Brian · North Attleboro, MAN26KDHuntington James R · Indianapolis, INN26KFCarma LLC · Kalispell, MTN26KLLepping Kurt · Hot Springs, MTN26KNSky King Aviation Inc · Weslaco, TXN26KSMrd Aero LLC · Manheim, PAN26LALead Aviation Fl2 LLC · Osprey, FLN26LJN26lj LLC · Oklahoma City, OKN26LLGmr Leasing LLC · Lincoln, DEN26LMClassic Aviation Inc · Pella, IAN26LPAb Prop Plane II LLC · Metairie, LAN26LZHarrison Ashley L · Danbury, CTN26MDMccue Gregory P · Cody, WYN26MF2nd Amendment Consulting And Design LLC · Red Bluff, CAN26MGWhitmus Christopher A · Bowie, TXN26MHZorrilla Peter · Charles Town, WVN26MLDay Brittney L · Inola, OKN26MPPompeo John · Gorham, MEN26NANatron Air Inc · Soldotna, AKN26POn Final Flying LLC · Altoona, IAN26PBMurphy Christopher K · Prescott, AZN26PMHill Capital Leasing LLC · Scottsdale, AZ
Back to AD 2007-04-19 R1