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.
N4799SMiller Charles B · Pass Christian, MSN4799TSale Reported · Omaha, NESale reportedN4799UChase 13 LLC · Wilmington, DEN4799VDeparture Aviation Services LLC · Laurel Hill, NCN4799WHudson Kelsey L · Snohomish, WAN479ACVick Vernon A · Dublin, OHN479BAJml Aviation Inc · Jonesboro, ARN479BKTensas Taildraggers LLC · Saint Joseph, LAN479CNFlight World Inc · San Juan, PRN479EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN479FLImmell John A · Chillicothe, OHN479HBDouble Bar Stationair LLC · Coeur D Alene, IDN479JAYale Companies LLC DBA · Indianapolis, INN479JLLopez Jesus D · Garfield, ARN479JPHogancamp John M · Lebanon, TNN479NTFlight World Inc · San Juan, PRN479SHParker Helicopter LLC · Watsonville, CAN479SVKollstedt Lance S · Tipp City, OHN479TWilson Chuck W · Mckinney, TXN47ACReabe Aircraft Improvement Inc · De Pere, WIN47AEPolar Air LLC · Bozeman, MTN47AFL & J Aviation Inc · Atwater, CAN47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKN47APAfrican Parks Aviation Inc Trustee · Cheyenne, WYN47ASM D Ham LLC · Conover, NCFirst renewal noticeN47ATPutman William C · Bigfork, MTN47BBRogers Joseph O III · Fernandina Beach, FLN47BCBrentech Leasing LLC · Cartersville, GAN47BDFlydreams Corp · Lewes, DEN47BGVonweisenstein Thomas W · Brentwood, TNN47BLLade Burton G · Bemidji, MNN47BNCavorite Aviation LLC · Lehi, UTN47CDRs Aviation Services · Moorpark, CAN47CFHover 32768 LLC · Kalispell, MTN47CPHibler Philip Earl · Alameda, CAN47CTSweetwater Flyers LLC · Emporia, KSN47CWPetersen Alfred Charles · Buffalo Grove, ILN47DBCala Brush Supply Inc · Weslaco, TXN47DCL&D Joint Sealing LLC · Fairbury, NEN47DERichards Ronald W · Grant City, MON47DHBeard Donald Ray · Bulverde, TXN47DLFairley Michael L · Shawnee, KSN47DSHalls Dave · Lilburn, GAN47ECRv Aviation LLC · Wilmington, DEN47EEGt Aviation Solutions LLC · Mount Juliet, TNN47EYWof Investments LLC · Dover, DEN47EZRinell Eric S · San Luis Obispo, CAN47FAAshe Olen Reid Jr Trustee · Winston Salem, NCN47FL3429 Capital Holdings LLC · Jupiter, FLN47GEMcbride Michael J · Loxley, AL
Back to AD 2007-04-19 R1