AD 2015-20-13
Registered aircraft · 5,444
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:2015-20-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-20-13')
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:2015-20-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-20-13') 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.
N2103MMontgomery William A · El Paso, TXN2104NHammond Brian R · Lincoln University, PAN2104UVeracy Aviation LLC · Arlington, VAN21052Registered aircraftN-number assigned, not yet registeredN2105UPiper Automotive & Marine Service Inc · North Miami, FLN21065Omni Management LLC · Decatur, ALN2106CRunde Dean G · Riceville, IAN2107DBreslow Arnold M · Dania, FLN2107EFly Kilo Charlie LLC · New Century, KSN2108CMetro Aircraft Co · Bloomington, MNN2109NStallings Farms Trucking LLC · Hertford, NCN210EZFaulkison Brian S · Watkins, CON21116Prestige Worldwide Aviation LLC · Downers Grove, ILN2111GScoggins Thomas H · Daytona Beach, FLN21123Paris Air Inc · Vero Beach, FLN2112GA&J Aircraft Leasing Inc · Burlington, CON2112KRocky Mountain Aircraft Services LLC · Broomfield, CON2112NV & R Aviation LLC · Georgetown, TXN2112ZWilson Mickey Ray · Skagway, AKN21131Emge Douglas W · Albertville, ALN2114FChapel Hill Flying Club DBA · Sanford, NCN2114JMonaco Joseph · Castleton, VTN2114KRcs Services LLC · California, MDN2115JMartin Aviation LLC · Bargersville, INN21167Tidewater Aviation LLC · Easton, MDN2116FVarani Hugo Leonardo Cordova · Houston, TXN2116JWard John C · Novato, CAN2116UBreaux Family Investments LLC · Alexander City, ALN2117EWright Christopher Andrew · Lynn, MAN211NJCoco Aircraft Inc · Merritt Island, FLN211VMGuardian Flight LLC · South Jordan, UTN2122JCharles City Aeronautics Inc · Charles City, IAN2122LWare Pat · Farwell, TXFirst renewal noticeN2123AItechnology Design Inc · Gypsum, CON2123JRegistered aircraftN2123KStone Kent H · Franklin, TNN2124FHesseltine Robert J · Grand Terrace, CAN2124JDomas Jeffrey P · Mankato, MNN2127PDerbenwick Gary F · Colorado Springs, CON21288Cunningham Campers Inc DBA · Clarksville, INN212DXPiper Aircraft Inc · Vero Beach, FLN212TVParagon Airplane Leasing Co · Fort Myers, FLN2130CDurrett Bentley K · Rusk, TXN2130JEarly Bird Aviation LLC · Rillito, AZN2131JAllen Harvey · Elfrida, AZN21323A2t Guys Aviation LLC · Williamston, MIN2132JHolley William M · Rock Port, MON2133JHoosier Aviation LLC · Terre Haute, INN2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJN2134ERice Larry Anthony Trustee · Yucaipa, CA
Back to AD 2015-20-13