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.
N3173ESkywarrior Flight Training LLC · Pensacola, FLN3173FJames Pearl LLC · Norfolk, VAN3173QRosner Gary A · Enfield, CTN3173RRona LLC · Phoenix, AZN3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeN3173TAir Tango LLC · Martinez, GAN3173WFlying Hammer Aviation LLC · Crosslake, MNN3174BBrydon Robert J · Lago Vista, TXN3174DRegistered aircraftN3174FRozier Harold H Jr · Blackshear, GAN3174KLrs Dynamics Corp · Port Orange, FLN3174QMclaughlin Daniel R · Xenia, OHN3174RSeifert Richard W · Big Bear City, CAN3174TChartwell Services Inc · Wilmington, DEN3174UMorris Debbie L · Columbus, GAN31754Idlewild Aviation Inc · Lewes, DEN3175CClay Jason I · Imperial Beach, CAN3175FEstes Bernard R · Bumpass, VAN3175PBarlow Michael Kevin · Griffin, GAN3175QMarshaltown Aviation Inc · Marshalltown, IAN3175UKeller Richard J · Martinsburg, WVN3175WKristoffer & Co · Jacksonville, FLN3175YPittman Joel C · Apple Valley, CAN3176CYoung Thomas O · Battle Ground, WAN3176PN3176p LLC · Titusville, FLN3176UWilburn Michael R · Wagoner, OKN3176WTarvair Eclipse LLC · Burnsville, NCN3176YThomas Steven Dale · Monticello, ILN3176ZKielty Ronald · Ocala, FLN3177Duvall John M III · Cincinnati, OHN31770Reenders Michael D · Spring, TXN3177CRsb Properties LLC · Lewes, DEN3177NBcs99 LLC · Peoria, ILN3177PQualitair LLC Trustee · MichelstadtN3177RLaviano Kenneth J · Westwood, NJN3177SFreeman William R · Lenexa, KSN3177TCain James W · Big Rapids, MIN3177VSmith Daniel P · St George, UTN3177WCraniatwo LLC · Peoria, ILN3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeN3177ZMorris David P · Inverness, FLN3178High C Farms · St John, KSN3178AMarine Aviation LLC · Hanover, NHN3178DSager Kenneth A · Hummelstown, PAN3178TAdvantage Aviation Services LLC · South Saint Paul, MNN3178YNiles Air LLC · Concord, NCN31792Airscape Photo LLC · Issaquah, WAN3179AEsslinger Jamie · Valley Center, CAN3179CWoods Kevin M · Spokane, WAN3179DPreiss James M Trustee · Poplar Grove, IL
Back to AD 2007-04-19 R1