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.

N4800PFun Country Soaring · Avon Lake, OHBuilt 1968 · S/N 25-4580 N4800SWaalewyn Tracy W · Clermont, FLBuilt 1969 · S/N 32-1185 N4800VRegistered aircraftBuilt 1980 · S/N 172RG0382 N4800ZGorzynski Dustin B · Great Falls, MTBuilt 1961 · S/N 22-8367 N4801GFrederick Aero Development Inc · Murrieta, CAS/N 17273349 N4801LWilliams Fire Apparatus Inc · Ashland, ALBuilt 1967 · S/N 28-4140 N4801ZButler Delbert C · Caldwell, IDS/N 22-8368 N48024Aftcloud Inc · Ontario, CABuilt 1979 · S/N 15283270 N4802JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30603 N4802LKrishna Vijay · Appleton, WIBuilt 1967 · S/N 28-4141 N4802TSmith Terry G · Kamuela, HIS/N 28R-7235111 N4802ZHoffman James R · Bethel, AKBuilt 1962 · S/N 18-7800 N4803Molek Jon · Warren, OHS/N 1126 N48033Franconi Michael J · Newington, CTBuilt 1979 · S/N 15283271 N4803FNorman Howard A · Freeport, ILBuilt 1976 · S/N 28-7715067 N4803GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 17273351 N4803JWhite Jack D · Orangevale, CABuilt 2012 · S/N S94120077 N4803LJc And Co Menswear Inc · Tulsa, OKS/N 28-4142 N4803SEsmailka Harold E · Ruby, AKBuilt 1969 · S/N 32-1188 N4803TValiair Lc Trustee · Casper, WYBuilt 1981 · S/N R18201770 N4803ZBuffalo Flyers LLC · Buffalo, MOBuilt 1961 · S/N 22-8370 N48042Simmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 15283273 N4804AMakely Abraham M · Culpeper, VABuilt 1956 · S/N 22-3956 N4804EPrestar Inc · Davis, CABuilt 1978 · S/N 17271665 N48056Little Duke Aviation LLC · Saint Paul, MNBuilt 1979 · S/N 15283276 N4805GTidewater Flying Club Inc · Newport News, VABuilt 1979 · S/N 17273353 N4805LPrunty Gregory A · Saint Peter, MNBuilt 1967 · S/N 28-4144 N4805VBudulas Peter Panagiotis · Laurel, MDBuilt 1980 · S/N 172RG0384 N4805ZWittman Kristofer L · Anchorage, AKS/N 22-8372 N48068Ikarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N 15283277 N4806AButler David B · Ipswich, MABuilt 1956 · S/N 22-3958 N4806BMckinney Brett A · Hackleburg, ALBuilt 1979 · S/N 15283647 N4806FSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496095 N4806GStone Howard L · Pine Mountain, GABuilt 1979 · S/N 17273354 N4806SJohnson Mack W · Guymon, OKBuilt 1969 · S/N 32-1190 N4806TGardner Robert · Dixon, CABuilt 1972 · S/N 28-7225207 N4807BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283648 N4807DRussell Matthew D · Chattaroy, WAS/N 17272363 N4807GAdnd LLC · New Ipswich, NHBuilt 1979 · S/N 17273355 N4807JNew England Aviation LLC · Plainville, CTBuilt 1979 · S/N 17273680 N4807TAdams Kent C · Hubbard, ORBuilt 1972 · S/N 28-7225209 N4807YMayes Noelle C · Williams, CAS/N 25-4555 N4808FYankee Flying Club Inc · Maple Grove, MNBuilt 1979 · S/N 17273084 N4808LGifford Jerald O · Idaho Falls, IDS/N 28-4147 N4808SAxim Aero LLC · Miami, FLBuilt 1969 · S/N 32-1192 N4809LLuxl Frank S · Wilmington, DEBuilt 1967 · S/N 28-4148 N480JPWells Vance · Battle Ground, WABuilt 2003 · S/N 40.280 N480NROhio Division Of Wildlife · Columbus, OHBuilt 1986 · S/N 345 N480SCZephyr Services LLC · Long Beach, CABuilt 1978 · S/N R18200455 N480SPDhs Operations LLC · Wilmington, DEBuilt 1998 · S/N 172S8025

Back to AD 81-18-04 R2