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.
N31536Island Air Taxi LLC · Put In Bay, OHN3153BSeverson James A Jr · Tualatin, ORN3153CCulver Marc D · Anchorage, AKN3153DN3153d LLC · Middletown, DEN3153HChristensen David R · Brigham Cit, UTN3153LMiller James R · Parowan, UTN3153PWhiskey Mike Aviation LLC · Merrimac, WIN3153QMaine Mold & Machine Inc · Hartford, MEN3153TRegistered aircraftN3154CMitchell Barry C · Sagle, IDN3154DJohnson Daniel P · Pardeeville, WIN3154FMetcalf Management Inc · St George, UTN3154LOnisko Aidan C · Williams, CAN3154RKuchera Ray A · Rockdale, TXN31551Hawaii Pacific Aviation Inc · Kailua Kona, HIN3155BCountry Development LLC · Lebanon, ORN3155CNolan Michael William Jr · Silver Spring, MDN3155DNervino Blake · Turlock, CAN3155FHansen Jeremy · Burlington, CON3155QLandro Rebecca · Puyallup, WAN3155REnright Matthew R · Skiatook, OKN3155SSterling Flight Training LLC · Jacksonville, FLN3155TRobbins Charles R · Trout Creek, MTN3155YBult Equipment LLC · Monee, ILN3155ZKrejci Dwight D · Wheatland, WYN31563Hfd Aviation LLC · Salem, VAN31565Datema Steven K · Susanville, CAN31569Snyder Bradley R · Johnstown, PAN3156CMarshall Robert L · Pine River, MNN3156GBlack Ops Aviation LLC · Moorhead, IAN3156PLumley William · Delray Beach, FLN3156RChamplain Robert F · Canton, ILN3156TSpring Mitchell L · Saint Cloud, FLN3156XBack Country Aviation LLC · Jupiter, FLN3156YGrant Robert N · Pollock Pines, CAN3156ZSale Reported · Wellsville, UTSale reported, canceledN31571Cg Air LLC · Mason City, IAN31573Miller Gerald L · Selinsgrove, PAN3157GBrushpopper Aviation LLC · Annona, TXN3157HBroughton Tim · Lucas, TXN3157QVowell Gregory · Coffeyville, KSN3157THollrah Kenneth R · Enid, OKN3157UDavison Cornelius Harry Jr · Phoenix, AZN3157YBrennand R44 LLC · Neenah, WIFirst renewal noticeN3157ZIvy James E · Alba, TXN31581Lesher Jesse L · Walton, KYN31583Redel Michael R · Gasquet, CAN31586Nichols Jan L · Bonham, TXN31589Redemption Leasing LLC · Kodiak, AKN3158FTw Enterprises Inc · Naperville, IL
Back to AD 2007-04-19 R1