Skip to content

Registered aircraft · 5,443

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

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') ORDER BY n_number

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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N552PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842089 N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090 N553SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881342 N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105 N554PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842091 N554RRegistered aircraftBuilt 1976 · S/N 28-7690382 N555HAYasko Gary R · Gallipolis, OHBuilt 1978 · S/N 28-7916125 N555JMFingerlakes Area Pilots Inc · Seneca Falls, NYBuilt 1979 · S/N 28-7916412 N555PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842092 N555QFColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1992 · S/N 2890173 N556SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881343 N557DTRedace LLC · New York, NYBuilt 1985 · S/N 28-8690022 N557PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842094 N5586VFisher Robert W · Katy, TXS/N 28-7716183 N5587VNorth Country Aviation LLC · Kalispell, MTS/N 28-7716184 N5589VKempton Larry G Jr DBA · Grand Junction, COS/N 28-7716185 N558KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843879 N5592VBlack Dog Air LLC · Satellite Beach, FLBuilt 1977 · S/N 28-7790482 N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096 N55JDAviation Capital Management LLC · San Jose, CAS/N 28-7790579 N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103 N560APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843763 N560PUPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 2842098 N5613VKempton Larry G Jr · Grand Junction, COS/N 28-7716187 N561BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010040 N561MAMcdonald Jeffrey D · Chilmark, MABuilt 2003 · S/N 2843561 N561MHDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 28-7690264 N561PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842103 N561SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881399 N561TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881861 N562AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881814 N562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 2842104 N5639FTaffet Jay · New Orleans, LABuilt 1976 · S/N 28-7790132 N563APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843764 N563DFGolden Aviation LLC · Hillsborough, NJBuilt 2022 · S/N 2881563 N563KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843936 N563MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020139 N563PUAri Ben Aviator Inc · Fort Pierce, FLBuilt 2000 · S/N 2842105 N563SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881400 N5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188 N5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133 N564KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843880 N564PUPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 2842169 N5654VHodges Tandi R · The Woodlands, TXBuilt 1977 · S/N 28-7716190 N5658VN5658v Aviation LLC · Huntsville, TXBuilt 1977 · S/N 28R-7737067 N565LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881905 N565TFAir Therapy LLC · Chapel Hill, NCBuilt 2022 · S/N 2881565 N5662VLoft Aire Inc · Venice, FLBuilt 1977 · S/N 28-7716192 N5663VUniversal Aviators Academy Inc · El Monte, CAS/N 28-7716193 N5664VWarrior Leasing Corp · Wilmington, DEBuilt 1977 · S/N 28-7716194

Back to AD 2016-07-21