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.
N567PBNorthbound LLC · Wasilla, AKN567RRGist Aviation LLC · Austin, TXN567RSSpitler Robin C · Statesboro, GAN567RVMarini Robert A · Brighton, CON567SDBordett Jason Scott · Palm Beach Gardens, FLN567SFCockpit LLC · Melbourne, FLN567SHSpitzer Helicopter LLC · Wilmington, DEN567SPAb Prop Plane II LLC · Metairie, LAN567TB567tb LLC · Rockford, OHN567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationN567TXWatts Brian W · Houston, TXN567UPDodson Robert B · Harvard, ILN567VEEngbring Jered · Durango, CON567XCovert Tim · Portland, ORN567ZZulu Aerospace Services LLC · Prescott, AZN56809Hudak Susanne Marie · Gold Canyon, AZN5680BTveitnes Svein T · Whitewright, TXN5680CSea Spray Aviation LLC · New Smyrna Beach, FLN5680JKnutson Wayne R · Thompson, NDN5680KHarkness Douglas M · Chicago, ILN5680VTime To Fly LLC · Cleveland, MSN5680WGoines Courtnee J · Jacksonville, FLN5680YSchildberg Gregory M · Casey, IAN5681QSteixner Jessica M · Madison, TNN5681SHillcrest Aviation LLC · Midland, TXN5681VNewell & Sons · Roxboro, NCN56821Cowlin Aviation LLC · Houston, TXN56822Tanner Timothy S · Norton, KSN56823Fly Tu9 LLC · Vancouver, WAN56828Gillette Daniel R · Chillicothe, ILN5682QNagel Mildred J · Akron, OHN5682VSgm Contractors LLC · Great Falls, VAN5682WRiggin Flight Service Inc · Madison, SDN56831Burns Robert A · Fort Myers, FLFirst renewal noticeN56834Maslonka Bradley James · Prior Lake, MNN56836Spj Aviation Holdings LLC · Bentonville, ARN5683UMccarver Tyler L · Wharton, TXN5683WYanta Chris · Rockport, TXN56847Nepsund Michael L · Park Rapids, MNN56849Macair Aviation LLC · Xenia, OHN5684PAce Drilling LLC · Johnson, KSN5684WSeverino Racli · Closter, NJN56853Maxair Complex Flight LLC · Murfreesboro, TNN5685JAnderson Aerial Spraying Service · Canby, MNN5685PWalker Richard E · Quanah, TXN5685SGreen Taylor · Olympia, WAN5685UTres Amigos Flying Club LLC · Redding, CAN5685WRempel Steven P · Prague, OKN56860Horst Michael D · Chambersburg, PAN56861Wingsleasing LLC · Wichita, KS
Back to AD 2007-04-19 R1