Registered aircraft · 5,458

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.

N1250UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020246 N125LSchlamer Mark A · Campbellsport, WIBuilt 1980 · S/N 288090256 N125MTMcdonald Theresa C · Beaufort, SCS/N 2844093 N125VSMcfarland Joel E · Pittsford, NYBuilt 1979 · S/N 28-7990399 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127MTPilotsplane LLC · Boca Raton, FLBuilt 2003 · S/N 2844094 N1286GRegistered aircraftS/N 28-7990076 N1288HFly By Knight Inc · Hammond, LABuilt 1976 · S/N 28-7716011 N1290HWeiss Gregory K · Manitou Springs, COS/N 28-7716012 N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219 N129SAUnlimited Vertical LLC · Milton Freewater, ORS/N 28R-7737053 N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439 N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131 N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417 N1307HDileo Steven · Gallatin, TNS/N 28-7716015 N130JMSalty Skies Aviation LLC · Van Nuys, CABuilt 1982 · S/N 28-8390036 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130TLynch Machining LLC · North Vernon, INBuilt 2003 · S/N 2844104 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N1310UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020247 N1317HLightfoot Carl · Beaumont, TXS/N 28-7790304 N131CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881353 N131LLAims Community College · Greeley, COBuilt 2020 · S/N 2881345 N131PAAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020055 N132AMTemple James C · Lincoln, CABuilt 1978 · S/N 28-7990245 N132BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843583 N132CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881354 N1341HAlseth Engineering LLC · Kirkwood, MOS/N 28-7790306 N1342HRobertson James P Trustee · Templeton, CABuilt 1977 · S/N 28-7790307 N1344HConner W Larry · Los Lunas, NMBuilt 1977 · S/N 28-7790308 N134FCDepartment Of Agric & Consumer Svc/S · Tallahassee, FLBuilt 1982 · S/N 28-8290169 N134WSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 28020137 N135EG305 Aviation Group Inc · Miami, FLS/N 28-8290170 N1362HRegion Flyers LLC · Valparaiso, INS/N 28-7716018 N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N1377HParis Air Inc · Vero Beach, FLS/N 28-7716019 N137ATChamerlik William S · Spencer, TNBuilt 1977 · S/N 28-7816087 N137BCJrnd Corp · Lewes, DEBuilt 2003 · S/N 2843584 N137CCMore Right Rudder LLC · Sioux City, IABuilt 1977 · S/N 28R-7737065 N137NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010008 N1382HCaba Edward M · Malvern, PAS/N 28-7790309 N1386HRodriguez Luis D · Davenport, FLBuilt 1977 · S/N 28-7790310 N1386TGeorgia Aviation Authority · Eastman, GABuilt 2003 · S/N 2844101 N138BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843580 N138BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881955 N138FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1982 · S/N 28-8290102 N138VAMysky LLC · Saint Louis, MOBuilt 2023 · S/N 28020112 N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174 N1404HMiller Shawn C · Milaca, MNS/N 28-7716023

Back to AD 2016-07-21