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.
N409RCrawford Russell W · Hurricane, UTN409RWAllred Mike · Thomasville, NCN409SHSky Solutions LLC · Westland, MIN409SJKirsh & Kirsh P C · Indianapolis, INN409SSBlackwell Aviation Inc · Bell Vernon, PAN409TPParagon Airplane Leasing Co · Fort Myers, FLN409VRegistered aircraftN409XDunn Blake · Bristol, CON409XXPope James D · Clarkston, WAN40ABSchumacher Steven Joseph · Fayetteville, ARN40ACRadecki Louis · Helenville, WIN40AESchwartz Michael · Missoula, MTN40ASSchaad Rene · Arroyo Grande, CAN40ATN40at LLC · Lewis Center, OHN40AWKlingbeil Mark T · Bottineau, NDN40BBPawlak Jakub Piotr · Lafayette, INN40BLK & B Real Estate Holdings LLC · Huntley, MTN40BXBreton Michael A · Avon Lake, OHN40BYMassengill Brad · Lowell, INN40CBBurnett Chad H · Draper, UTN40CFG&M Flyers LLC · Wilmington, DEN40CKDcy Aviation Group LLC · Linton, INN40CMKline Timothy L · Elverson, PAN40CRMoyer Gregg A · Haymarket, VAN40CSSoloy L Chris · Wasilla, AKN40CZBeast Aero Consulting And Training LLC · Rosamond, CAN40DACirrus Design Corp · Duluth, MNN40DCWright Innovators LLC · Sebastian, FLN40DLStyer David B · Pendleton, ORN40DRRoss David R · Wakeman, OHN40DZSt. Bernard Aerial LLC · Kalispell, MTN40ECHill Richard C · Buckeye, AZN40EHHibler Phillip E · Alameda, CAN40EMYour Moms Upset LLC · Saint Paul, MNN40ERFlying Aces Aero Fleet Inc · Guyton, GAN40ESP.C. Air LLC · Lockport, NYN40FAWright Paul G Trustee · Scotts Valley, CAN40GHagerty Environmental LLC · Kennett Square, PAN40GBSlb Enterprises LLC · Newark, DEN40GDSimply Living LLC · Fort Myers, FLN40GECuckler Dale E · Tulsa, OKN40GMSteven E Cox · Bend, ORN40GRPetao LLC · Trinity, FLN40GVHauser Paul J · Longmont, CON40HFVogel Essex Nathaniel B · Berkeley, CAN40HUMoore Charles B · Miles City, MTN40HYHendrickson Dale W · Denton, TXN40JTav8rs LLC · Tea, SDN40JAJersey Aero Club Inc · Lakewood, NJN40JBElk River Aero LLC · Noel, MO
Back to AD 2007-04-19 R1