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.
N3075UEvans Ronald G · Imlay City, MIN3075XOrthoredlands Leasing LLC · Redlands, CAFirst renewal noticeN3075YAir Eagle LLC · Rome, GAN30760Gibson Brock E · White Salmon, WAN30761Feaster Christopher D · Richmond, INN30763Stith Gregory C · Osprey, FLN30765Hope Michael J · Exeter, NHN30767Cardinal N30767 LLC · Germantown, TNN30769Fridley R Mark · Owasso, OKN3076EHinkes Kenny · Albuquerque, NMN3076MMckinney Leonard F Co Ow · Anchorage, AKN3076QLong Eric S · Assumption, ILN3076TPoint Two Six Avation LLC · Scottsdale, AZN30771Dodson International Parts Inc · Rantoul, KSN30774Stucco Supply Co Of San Jose Inc · San Jose, CAN30777Huff Charles Christopher · Midland, TXN3077EBlackhawk Holding Corp · Wilmington, DEN3077FBlake Jason E · Shreveport, LAN3077HAir Frame Worx LLC · Wilmington, DEN3077KBaldus Scott William · Waxhaw, NCN3077MPremier Flight Center LLC · Hartford, CTN3077U3077u LLC · Dallas, TXN3077WWipaire Inc · South Saint Paul, MNN3077XSmith Jessica L · Palouse, WAN3077ZBravo Air LLC · Troy, MIN30785Colleran Michael · Suamico, WIN30786Gettys John E · Cabool, MON30787Jetsons Holdings LLC · Birmingham, ALN30789Gccs Corporation · Danville, PAN3078CLarsen Michael R · Fort Polk, LAN3078HHorn H Fred · Cedar Rapids, IAN3078JRobertson Crop Dusting Service Inc · South Haven, MIN3078RKitaguchi Terry S · Stockton, CAN3078YDodson International Parts Inc · Rantoul, KSN3078ZSeiter Randy R · Lake Isabella, MIN30790Cammarato Thomas Angelo · Aguila, AZN30794Wilkinson Thomas W II · Spring, TXN30797Johnson Alan L · Pikeville, KYN3079BHarris William C · Gladstone, NJN3079CTre Aviation Corp · Wilmington, DEN3079FMackay Chadd P · Spokane Valley, WAN3079LTff Inc · Parma, MIN3079MEagle Flight Academy LLC · Owensboro, KYN3079RGrace Ryan Aviation LLC · Tomball, TXN3079USpicher Samuel C Jr · Harrisonburg, VAN3079WFerr Air Ltd · Southampton, PAN3079YAustin Bill · Laurel, MTN3079ZOcchipinti Mark A · Springdale, ARN307AKRotor Rascals LLC · Anchorage, AKN307BMBow Mac Aviation LLC · Spring Lake, MI
Back to AD 2007-04-19 R1