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.
N51PHAasen Christopher N · Corvallis, ORN51PSEastern Stearman Inc Trustee · Leesburg, VAN51PVCrupi John · Fort Lauderdale, FLN51PWVerroi Timothy A · Beaufort, SCN51QTGordon David A · Sitka, AKN51RMiozzi Thomas E · Jamestown, RIN51RAK And D Aviation Inc · Robbinsville, NJN51RBShenk David K · Longmont, CON51RJJones Robert B Trustee · Fresno, CAN51RVSwiatek Glenn E · Montrose, CON51SARedtail Partners LLC · Moab, UTN51SJSmith Bradlee W · Georgetown, TXN51SMSolomon Steven D · Prospect Hill, NCN51SPDepartment Of Public Safety · Dover, DEN51STCnc Aerobatics LLC · Ada, MIN51SWDelaware Valley Aviation Inc · Langhorne, PAN51TBSorenson Gary Trustee · Storden, MNN51TCCurtis Ted N · Huntington, UTN51TPStewart Dale S · Las Vegas, NVN51UDAlf Ix LLC · Chicago, ILN51VBPiper Aircraft Inc · Vero Beach, FLN51VKGaudreau Henry J · Chesaning, MIN51WAPennewell Solutions LLC · Dover, DEN51WDWyatt Greg · Summerville, GAN51WT51 Whiskey Tango LLC · Henrico, VAN51XASturges George S Jr · Bakersfield, CAN51YTRupp Steven S · Cameron Park, CAN52004Jones Steve M · Anchorage, AKN52009Sale Reported · Palmer, AKSale reportedN5200ABarr Air Patrol LLC · Mesquite, TXN5200EViaene Tajae L · Fargo, NDFirst renewal noticeN5200GReed Conrad H · Centre, ALN5200HIowa Lakes Community College · Estherville, IAN5200LDecker Michael · Baxter, TNN5200QBas Part Sales LLC · Greeley, CON5200TUding Michael E · Sainte Genevieve, MON5200XRwr Air Inc · Tok, AKN52010Bentley John R · Bend, ORN52012Skylens LLC · Hammond, LAN52013Hillsboro Aero Academy LLC · Hillsboro, ORN52016Lil' Dawg Aviation Inc · Oxford, MSN5201ADan Howard Aircraft Sales LLC · Tulsa, OKN5201CCordero Jose Robert · El Paso, TXN5201DGriffin Thomas S · Spartanburg, SCN5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLN5201HGorge Winds Aviation Inc · Fairview, ORN5201LMelchiorre Joseph G Jr · Milton, DEN5201NMarr Christopher M · Morrisville, NCN5201QAdams Clive P · Hendersonville, TNN5201RWest Florida Flying Service LLC · Safety Harbor, FL
Back to AD 2007-04-19 R1