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.
N5278WJohns Tyler B · Folsom, CAN5278XFisher Bryan S · Galveston, TXN52792Ball Richard W · Ridgefield, CTN52794Hawk Flyer 794 LLC · San Bruno, CAN52795Key Lime Consultants LLC · Belleview, FLN52797Supinie Andy · Wichita, KSN5279DDay Aviation Inc · Wilmington, DEN5279GArnold Jason Mcree · Watkinsville, GAN5279LCarverair LLC · Lakeland, FLN5279MTownsend Tod N · White Sulphur Spgs, MTN5279TDicecco Jennifer · West Chester, PAN5279WAmerican Aviator LLC · Arlington, TXN527ABPriest Justin E · Arlington, WAN527AWSkyhawk Td LLC · Siloam Springs, ARN527BCYager Greg J · Columbia Falls, MTN527BHRed River Cellular Telephone Corp · Paris, TXN527BKShires Patrick O · San Andreas, CAN527CCUS Department Of The Interior · Boise, IDN527CDAircraft Medical Solution LLC · Kissimmee, FLN527CGGibbs Tyler · Gilbert, AZN527DAltman Aviation Services LLC · Lockhart, TXN527DSSkyhawk Leasing LLC · Greenfield, INN527ECRdec LLC · Wilmington, DEN527FPhillips Flying Inc · Saluda, NCN527FLPatterson Roy A · Cameron, TXN527GTSchellhase Walter S · Kerrville, TXN527JBSoutheast Anesthesia Plc · Mcdonald, TNN527JHTugende LLC · Montrose, CON527JPPerritt John Olin III · Clayton, NCN527LMacan Ed · Overland Park, KSN527MLMoss Herman D · Centreville, VAN527NDPhoenix East Aviation LLC · Daytona Beach, FLN527RJGonzales Denise E · Fort Worth, TXN527RSRamsey Wayne V III · Abilene, TXN527SPRose Arthur K · Florence, ALN527TFlying H Enterprises LLC · Smithville, MON527TAPlane Leasing LLC · Wilmington, DEN527TCLeonardo Paul A III · Merced, CAN527TMCampbell Air Services Inc · Roseville, CAN527TRDawson Kevin · Colorado Springs, CON527VBPipping Construction LLC · Rosendale, WIN527VMBradley Christopher · Orange, TXN527WMitchell Grayson · Milledgeville, GAN527WPProctor Justin Paul · New Bern, NCN527YMues John C · Wasilla, AKN52806Skywarrior Flight Training Inc · Pensacola, FLN52808Thane Inc · Elkridge, MDN5280DHdw Florida Helicopters Inc · Pompano Beach, FLN5280EStreeter Byrand DBA · Newcastle, WYN5280MN5280m LLC · Elizabeth, CO
Back to AD 2007-04-19 R1