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.

N350BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881691 N350MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881439 N350MLPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 2843594 N351MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881440 N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350 N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462 N352ACFlight Leasing Corp · Wilmington, DEBuilt 2006 · S/N 2842277 N352BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881692 N352MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881441 N352VAVictory Aviation Club Inc · Hamilton, OHBuilt 1976 · S/N 28-7690224 N352ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881642 N3530MComer Robert E · Greensburg, INBuilt 1978 · S/N 28-7890309 N35319Yoder Electric Inc · Monticello, GABuilt 1978 · S/N 28-7816607 N35321Manuel Greg R · Pecatonica, ILBuilt 1978 · S/N 28-7816606 N3533MBrowning Gregory S · Deputy, INBuilt 1978 · S/N 28-7890311 N353ACHoffberger Bruce S · Baltimore, MDBuilt 1998 · S/N 2843161 N353BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881747 N353MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881442 N353ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881643 N3547MBernstein Matthew D · North Charleston, SCBuilt 1978 · S/N 28-7816354 N354BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881777 N354MAAir Shares LLC · Casper, WYBuilt 2003 · S/N 2843545 N354MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881501 N3552MArcher Enterprises Inc · Sac City, IABuilt 1978 · S/N 28-7890313 N3553MIxi LLC · West Bloomfield, MIBuilt 1978 · S/N 28-7890314 N3554MWacker Peter K · Marietta, GAS/N 28R-7837123 N3559MMoyer Josiah E · Paradise, PABuilt 1978 · S/N 28R-7837124 N355DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843843 N355MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881502 N3560ECrawford James M · Sparta, MIBuilt 1979 · S/N 28-8016186 N3560VAmdor John E · Harlan, IABuilt 1979 · S/N 28-8090182 N3562GTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1979 · S/N 28-8090186 N3562LAndersen Kim · Yucaipa, CABuilt 1980 · S/N 28-8090187 N35671Clemons Preston J · Andover, KSBuilt 1979 · S/N 28-8016204 N35689Faulkison Brian S · Watkins, COBuilt 1979 · S/N 28-8090193 N3569DFtaviation LLC · Chantilly, VABuilt 1979 · S/N 28-8090168 N356ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010056 N356BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881805 N356MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881503 N356NDAir Shares LLC · Casper, WYBuilt 2003 · S/N 2842184 N35705Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016207 N3571CEgan Michael S · El Paso, TXS/N 28-8016209 N3572MPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7816356 N3572XKelsoe Gregory Lyle · Clermont, FLBuilt 1979 · S/N 28-8016213 N35732Minney Andrew · Memphis, TNBuilt 1979 · S/N 28-8016195 N35734Registration Pending · Blairsville, GARegistration pendingBuilt 1979 · S/N 28-8016199 N3574CAtd Pilot Training LLC · Kansas City, MOBuilt 1979 · S/N 28-8016200 N3574JI.F.C. Inc · Wayne, NEBuilt 1979 · S/N 28-8090196 N3574KDes Moines Flying Club LLC · Indianola, IAS/N 28-8090197 N35755Varin Joseph J · Smithfield, RIBuilt 1979 · S/N 28-8090200

Back to AD 2016-07-21