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.
N27150Auspex Inc · Houston, TXN27155Registered aircraftN27156Dailey Hadrian B · Churchville, NYN2715FLow Wings Aviation LLC · Gassville, ARN2715PNefstead Charles R · Willmar, MNN2715TDelaware Aircraft Trust LLC Trustee · New Castle, DEN2715YEmerson Michael J · Athens, ALN2716PNeno Richard J · Ithaca, NYN2716WBig Sky Aviation LLC · Meridian, IDN2716XShaw Brandon L · Juneau, AKN2716ZWilson Miles · Mcminnville, TNN27176Rayfield Wm Preston · Columbiana, ALN2717AMitchell Matthew · Roanoke, TXN2717GKlotz Terrance M · Sparks, NVN2717TIberlin James M · Gillette, WYN2718AOmega2alpha Services LLC · Brock, TXN2718FJackalope Flyers LLC · Whitefish, MTN2718QJenerette Marcus · Galivants Ferry, SCN2718XPoirier Theodore N · Biddeford, MEN2718YRichland Aviation Inc · Sidney, MTN2719FSjoblom Erik Anders · Washington Twp, MIN2719MCenter Charles C · Wasilla, AKN2719RJenkins Bruce D · New Market, MDN2719WNance Russell · Pelion, SCN271APatty Wagstaff Aviation Safety LLC · Saint Augustine, FLN271AFBurke Aircraft Service Co LLC · Portsmouth, OHN271AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN271AMMonthy Christian · Van Nuys, CAN271BSheridan Jeffrey Stephen · Lakeville, MNN271CACivil Air Patrol · Maxwell Afb, ALN271CCL-Bird LLC · Hood River, ORN271DCForum Aviation LLC · Middletown, DEN271DGMa King LLC · Stanwood, WAN271DWBundock David · Wayne, NJN271EXTakacs John Paul · Portland, ORN271FKPlane Fun Inc Tr Trustee · Snellville, GAN271GArcher Aero LLC · Wilmington, DEN271GTBroulik Robert L · Lisbon, IAN271HWHot Wings Aviation LLC · Fishers, INN271JGoossen Luke A · Rosamond, CAN271MAWing Runner Aviation LLC · Lakewood Ranch, FLN271MDDismore Matthew · Gulfport, MSN271MGGeorgia Aviation Authority · Eastman, GAN271MLKeyser Gary E Trustee · Reno, NVN271MMFoster Gregory A · Saginaw, MNN271MWRobinson Loren L · Newark, DEN271PBClark Mayer Aviation LLC · Cross Roads, TXN271PTPinder Jason · Sheridan, WYN271RGCapitol City Flyers Inc · Madison, WIN271SBowker Mark · Bowdoinham, ME
Back to AD 2007-04-19 R1