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.
N2966FNansen Peter D · Bellingham, WAN2966KMichels LLC · Wasilla, AKN2966LCarpenter Robert E · Huntsville, ALN2966RTobin Michael A · Plain City, OHN2966TThomas Paul J · Oakland, MDN2966YPiper Holdings LLC · Osage Beach, MOFirst renewal noticeN2966ZKieffer William · Chillicothe, MON29673Olson Andrew S · Copper Canyon, TXN29677Anderson Aircraft Inc · Central City, NEN2967DCalifornia In Nice Inc · San Jose, CAN2967EBme N2967e LLC · Clearwater, FLN2967L2967lima LLC · Scott City, MON2967QPowell Samuel C · Burlington, NCN2967ZChance Carl R · Victoria, TXN2968AMcdowell Claude Michael · Anchorage, AKN2968PRankin Kevin · Maryville, MON2968XJansen Edward M · Hummelstown, PAN2968ZKuebler Terry T · Gahanna, OHFirst renewal noticeN2969LSeegers Matt J · Westlake Village, CAN2969SJorgensen Richard J · Vail, AZN2969TDoskicz Aircraft Specialties Inc · Bally, PAN296AQMcdonald Gregory W · Newnan, GAN296AREnvation LLC · Winter Haven, FLN296BJc Aircraft Leasing LLC · Wasilla, AKN296BCKrein Christopher L · Bismarck, NDN296BJQualitair LLC Trustee · MichelstadtN296CAAlice Aviation LLC · Atlanta, GAN296CBCalifornia Baptist University · Riverside, CAN296CPCivil Air Patrol · Maxwell Afb, ALN296DBWopuna Aviation LLC · Vancouver, WAN296DJPizzo Duane G · Warren, ORN296HLMcclanahan Edward A · Apo, AEN296HPInnova Air LLC · Encinitas, CAN296JPJpm Flying Service LLC · Marine, ILN296JRRosson Jeffrey K · Melbourne, FLN296LCCox Bradley K · Fairbanks, AKN296MAHot Wings Aviation LLC · Fishers, INN296MEJwl Aviation LLC · San Carlos, CAN296NWNorthwestern Michigan College · Traverse City, MIN296PEPhoenix East Aviation LLC · Daytona Beach, FLN296PLAerospring Leasing LLC · Wasilla, AKN296QSteffens Robert S · Peapack, NJN296RVRwa Inc · Garden City, KSN296SDHaynie Sidney S · Sedona, AZN296TWN296tw LLC · Murrieta, CAN296TXCrowley Michael G · Midland, TXN2970CClegg Bruce R · Brentwood, CAN2970ESparrowhawk Aviation · Manvel, TXN2970NGilcrease Patrick C · Rapid City, SDN2970PWilson Julie · Prineville, OR
Back to AD 2007-04-19 R1