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.
N477ALSimply Living LLC · Fort Myers, FLN477AMSpicher Samuel C Jr · Groveland, FLN477BGParker Dennis A · Charlevoix, MIN477CHCsi Flight Services LLC · Mcminnville, ORN477DCChildress David W · Coldwater, MSN477DKPhilippi Ranches Inc · Hermiston, ORN477EE477ee LLC · Bethany, OKN477GFState Of Alabama Department Of Conservation · Montgomery, ALN477GYGolf Yankee LLC · Haymarket, VAN477JGulf Airbatics Ltd · Jennings, LAN477LLLima Lima LLC · Lander, WYN477LMStampley Michael C · Mount Pleasant, SCN477MAThompson Layne A · Pollok, TXN477MERegistration Pending · Webster, NYRegistration pendingN477PCSaint Louis University · Saint Louis, MON477PSSilver Patrick F · Toney, ALN477RRadtke Jeffrey A · Norwalk, CTN477RBNwl Capital Holdings LLC · Black Eagle, MTN477RSSundbird Airlines Inc · San Juan, PRN477RVVans Aircraft Inc · Aurora, ORN477SFAps Asset Management Inc · Mesa, AZN477SPRegistration Pending · Leesburg, VARegistration pendingN477TPaetzold Benjamin T · Fort Worth, TXN477UVUtah Valley University · Orem, UTN477WCAllison Medical Solutions LLC · Lumberton, MSN4780APenn Flyers LLC · Greensburg, PAN4780ECarolinas Aviation LLC · North Myrtle Beach, SCN4780JItzchak Arzt · Sarasota, FLN4780LLemon Kyle · Santa Ynez, CAN4780RR&R Flight Services Inc · Mendota, ILN4780YPhiladelphia Glider Council · Hilltown, PAN47818Fischer Scott R · Spanaway, WAN47819Candace A Larned Enterprises Inc · Long Beach, CAN4781DGipe Douglas A · Malvern, IAN4781JWyatt Steven Joseph · Caddo Mills, TXN4781LPhillips James W · Lancaster, SCN4781NRobwin Air LLC · Lutz, FLN4781QStocker Russell · Woodland, CAN47820Vascular Wings LLC · Friendswood, TXN47824Morris-Reade Jeffrey M · Blaine, WAN4782DSwalling Matthew C · Wasilla, AKN4782GSeguin Elliot · Rosamond, CAN4782POlson Allan K · Tarpon Springs, FLN4782RSchulert Peter A · Lebanon, TNN4782TJordan Kevin · Brookline, NHN4783Haire Kenneth H · Star City, ARN47833Rtt Aviation LLC · Columbus, NEN47835Paddock Andrew S · Ainsworth, NEN47837Kolek Kirk A · Marion, IAN47839Ohara Daniel J · Naknek, AK
Back to AD 2007-04-19 R1