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.
N311AMBarr Air Patrol LLC · Mesquite, TXN311AWWidener Adam S · Sharpsburg, GAN311BGBluffton Flying Service Ltd · Bluffton, OHN311CBCampbell James S · Eloy, AZN311CFHronkin Jessie G · Palmer, AKN311CHWings Of Eaglz LLC · Lamoni, IAN311CKLima Tango Aviation LLC · Mount Dora, FLN311CTShahriari David B · Anaheim, CAN311DKKiefer David R · Boynton Beach, FLN311DR7427 Aviation LLC · Clovis, CAN311EFLibra Air Inc · Las Vegas, NVN311EHFive Six Zero One LLC · Orange, CAN311EXUpham Chester R III · Mineral Wells, TXN311FHJamieson Robert F · Friday Harbor, WAFirst renewal noticeN311FTR&D Land And Air LLC · St Simons Is, GAN311GBWhirlygig Enterprises LLC · Dover, DEN311GRPfeffer David D · Jacksonville, FLN311HBChristiansen Aviation LLC · Wilmington, DEN311JBJack Brain And Associates Inc · Castro Valley, CAN311JKHumphries John A · Elgin, SCN311JMN311jm LLC · Lake City, FLN311JWBonanza 311 Jw Limited · Urbandale, IAN311KKeeler Allan A · Woodbury, CTN311KGGrasse Alvin K · Longview, TXN311KMDream Flight Florida LLC · Wellington, FLN311KPPickard Kevin P · Washington, MIN311LRegistered aircraftN311LBNewton Michael A · Cameron Park, CAN311LLSimpson Anthony · Bozeman, MTN311LTSampson Terry W · Kimberly, ALN311LZIszak Lenard · Palm City, FLFirst renewal noticeN311MMAndrews Karen · Napa, CAN311MWS S Euroflyer III Ltd · Wilmington, DEN311NDUniversity Of North Dakota · Grand Forks, NDN311PDHaehnle Michael J · Milford, OHN311PGKumar Shekar · Greenwood, SCN311PJArras Leonard D · Canal Fulton, OHN311PSRegistered aircraftN311PWQuantic LLC · Morrisville, NCN311QGrant Roderick M · Dillingham, AKN311RAFlight Tech Inc · Arlington, WAN311RBFlying Ace 75 LLC · Wilmington, DEN311RGGriffith Thomas Alexander · Wellington, FLN311RHAnalysis Inc · Grand Junction, CON311RPPetersen Roger J · Newport, KYN311RWWashburn Harrill Gene Jr · Rutherfordton, NCN311SRed Rock Construction Inc · Hydro, OKN311SBNbr Aviation · Manassas, VAFirst renewal noticeN311SEDiamond B Farms Trucking Inc · Gamaliel, KYN311SFBaymag Aviation LLC · Mountain Home, AR
Back to AD 2007-04-19 R1