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.
N29EEEiland Eddie L · Dublin, TXN29EHRotary Run LLC · Zoar, OHN29ERCosta Air Service LLC · Painted Post, NYN29FAJetson Blue LLC · Palm Coast, FLN29FCUsda Forest Service Fepp · Raleigh, NCN29FJSkyjack Motorsports · Bettendorf, IAN29FLTorres Chris · Princeton, CAN29GHSutton Jaye Michael · Kaycee, WYN29GLHometime Rv LLC · San Antonio, TXN29HJTesmer Steven J · Marshall, WIN29HKKellogg John H · Skaneateles, NYN29HLSchreiber Christopher · Foley, ALN29HPRusso Kevin J · North Branch, NJN29HTTrede 2023 LLC · Aurora, ORN29HUClimb LLC · Kalispell, MTN29JDNyquist Mark R · Moorhead, MNN29JFJkg LLC · Murfreesboro, TNN29JJGourley Jonathon L · Graham, WAN29JLGriffin Justin B · Andrews, NCN29JRLulafay LLC · Lewes, DEN29JVPrado Mike · Sugar Land, TXN29KK29kk LLC · Manchester, MIN29KMDebonair Consulting Inc · Wilmington, DEN29KYBlack Ops Aviation LLC · Moorhead, IAN29LCareer Flyers LLC · Crittenden, KYN29LGCameron Mark · Alpine, WYFirst renewal noticeN29LLDenver Rock Island Railroad · Commerce City, CON29LPElbert John E · Rohnert Park, CAN29MFChas N Clark Associates Ltd · Laurel, MSN29MXPeterson Jim · Bedford, WYN29NAGula Jason · Scranton, PAN29NCBeasley Fred Scott · Tulsa, OKN29NEYankee Helicopters LLC · Plainville, CTN29PCFisher Douglas C · Mountain View, CAN29PDDonlan Paul V · Bellevue, WAN29PGGroves Morton Dan Patrick · Menlo Park, CAN29PJCastle Farms Inc · Sunnyside, WAN29PKKillcommons Peter · Independence, ORN29PMAlly Mohamed Yacoob · Fort Lauderdale, FLN29RBAdvantage Aviation Services LLC · South Saint Paul, MNN29RFCaldwell Rob · Danville, KYN29RGHappy Raptor Flying Club LLC · Fort Lupton, CON29RKRhk Of Kansas Inc · Jefferson City, MON29RMRedstone Arsenal Flying Activity · Redstone Arsenal, ALN29RPBridges Gary N · Vidor, TXN29RRKhg Aviation Holdings LLC · Columbus, OHN29RVKilby Brian C · Newnan, GAN29RXHey Aerial Application Services LLC · Childersburg, ALN29SCBrown Sherrie C · Cushing, OKN29SDRegistered aircraft
Back to AD 2007-04-19 R1