Registered aircraft · 81,733

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

N5351Robinson Herb · Snowflake, AZBuilt 1997 · S/N 073 N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411 N5351LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284298 N5351PPointair Aviation Inc · Port Jeff Sta, NYS/N 15284925 N5351QBarrett Dannie P · Halfway, ORS/N 17261778 N5351ZGostola Thomas · Fairmount, INBuilt 1961 · S/N 22-9072 N5352BRegistered aircraftBuilt 1958 · S/N 24-406 N5352DN5352d LLC · Costa Mesa, CABuilt 2002 · S/N 2844079 N5352KPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 17274077 N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655 N5352ULittle Dog Aviation LLC · Anchorage, AKBuilt 2003 · S/N 172S9385 N5352WRegistration Pending · Newton, ALRegistration pending, pending cancellationBuilt 1962 · S/N 28-413 N5352ZMcdougall Michael D · Caldwell, IDBuilt 1961 · S/N 22-9075 N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096 N5353HDe Nunzio Arnold J · Ballard, CABuilt 1979 · S/N 15284090 N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078 N5353RSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281157 N5353WYeager Brian · Locust Grove, GABuilt 1962 · S/N 28-416 N53540Orlando Aero Club Inc · Orlando, FLBuilt 1981 · S/N 17274776 N53541Ps N53541 LLC · Green Bay, WIBuilt 1981 · S/N 17274777 N5354DGonzalez Alejandro B · El Paso, TXBuilt 1979 · S/N 17272540 N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160 N5354SArcturus Bootes LLC · Wilmington, DEBuilt 1980 · S/N R18201552 N5354ZManson Timothy C · New Gloucester, MEBuilt 1961 · S/N 22-9077 N53558University Of Illinois · Savoy, ILBuilt 2002 · S/N 2844083 N5355FFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2003 · S/N 17281166 N5355LSeward Joe T Jr · Fairmount, INBuilt 1968 · S/N 28-4658 N5355PPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1981 · S/N 15284926 N5355QGorge Winds Aviation Inc · Fairview, ORBuilt 1981 · S/N 15285104 N5355WN5355w Partners LLC · Lehi, UTBuilt 2003 · S/N 17281167 N5355ZWatts Carrie L · Hazen, NVBuilt 1961 · S/N 22-9078 N53569New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9395 N5356DDethlefs Robert L · Clackamas, ORBuilt 1979 · S/N 17272541 N5356FFly By Knight Inc · Hammond, LANon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7715107 N5356HMurphey Stephen B · Lynchburg, SCBuilt 1949 · S/N 16-162 N5356LLehuta Steven C · Brunswick, OHBuilt 1968 · S/N 28-4659 N5356PChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9393 N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164 N5356WMahler Alex · Fayetteville, ARBuilt 1962 · S/N 28-420 N5356XSkywest Leasing Inc · St George, UTS/N 2843521 N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528 N53571George Michael F · Ferndale, WABuilt 1981 · S/N 17274781 N53572Arb Aviation LLC · Palm Harbor, FLBuilt 2002 · S/N 3246208 N53577New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9399 N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537 N5357EHoffman Dennis M · Winchester, VABuilt 1978 · S/N 17271840 N5357HRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15284092 N5357JArizona Bravo Lima LLC · Phoenix, AZBuilt 1980 · S/N 17273762 N5357KAir Hammer Two LLC · Gulf Breeze, FLBuilt 1951 · S/N 2257B N5357PSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15284927

Back to AD 81-18-04 R2