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.

N4387PAurora 17 Holdings LLC · Aurora, ORBuilt 1960 · S/N 23-1898 N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287 N4387TSkystat LLC · Forney, TXBuilt 1972 · S/N 28-7205155 N43885Paris Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8516032 N4388AVan Wagner Aerial Media LLC · Pembroke Pines, FLBuilt 1956 · S/N 18-4796 N4388CAlbert Lea Airport Inc · Albert Lea, MNBuilt 1984 · S/N 28-8516021 N4388JJohnson Kurt A · South Weber, UTS/N 28-22778 N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138 N4388TClear Skies Aviation Inc · Montgomery, TXBuilt 1971 · S/N 28-7205156 N4388ZWooliver Steve P · Wasilla, AKFirst renewal noticeBuilt 1968 · S/N 18-8714 N43899Smtm Holdings Inc · Wilmington, DEBuilt 1985 · S/N 28-8516033 N4389FFarooqi Muhammad M · Plano, TXS/N 28-7725013 N4389QMellinger Jason C · North Pole, AKS/N 17260289 N4389TBurchett James W · Seabeck, WABuilt 1972 · S/N 28-7205157 N4389VLeonard Nicholas Robert Eugene · Monument, COBuilt 1985 · S/N 28-8590028 N4389XRrg Software LLC · Alpine, CAFirst renewal noticeBuilt 1975 · S/N 28R-7635034 N4389ZZaczkowski Paul S · Tok, AKBuilt 1968 · S/N 18-8716 N438ACHickerson Timmy D · Greenfield, INBuilt 2000 · S/N 438-2000 N438CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 4496404 N438CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283345 N438DEAirduce LLC · Cheriton, VABuilt 2005 · S/N 1521 N438FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-24061 N438GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881178 N438JABaumgartner Richard L · Rossford, OHBuilt 2007 · S/N 70998 N438RMRocky Mountain College · Billings, MTBuilt 2019 · S/N 2881095 N438SATwopro Energy Services LLC · Odessa, TXBuilt 2016 · S/N 18282421 N438SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2018 · S/N 172S12225 N438SLGriffith Aviation Inc · Griffith, INBuilt 1979 · S/N 28-7916276 N4390JIsch Carl J · Geneva, INBuilt 1967 · S/N 28-22780 N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290 N4390SCandace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8516031 N4390ZAlsade Ltd · Big Piney, WYBuilt 1968 · S/N 18-8717 N4391FNorcal Flight Club · Vacaville, CABuilt 1976 · S/N 28-7715030 N4391JAvian Leasing LLC · Bremerton, WABuilt 1967 · S/N 28-22781 N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291 N4391RCheek Kenneth W · Yadkinville, NCBuilt 1974 · S/N 17263141 N4391XLyman Gregory B · Fiddletown, CABuilt 1975 · S/N 28-7615003 N4391ZAshby Scott J · Lemoore, CABuilt 1968 · S/N 18-8720 N4392APeterson Kerry J · Toston, MTBuilt 1956 · S/N 18-4801 N4392JOrtega Rene · Seaside, ORBuilt 1967 · S/N 28-22783 N4392MVinton Timothy R · Whitman, NES/N 12-3330 N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292 N4392XMountain View Aviation Inc · Honesdale, PABuilt 1975 · S/N 28-7690004 N4393FRegistration Pending · Laurel, MDRegistration pendingBuilt 1976 · S/N 28-7715031 N4393HHowell Bob · Washoe Valley, NVBuilt 2009 · S/N 058-111/112-898 N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293 N4393RHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17263143 N4393TJackson R Allen · Granbury, TXBuilt 1972 · S/N 28R-7235030 N4393XGriffin David R · Amarillo, TXBuilt 1975 · S/N 28R-7635035 N4393ZWilliams Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 18-8724

Back to AD 81-18-04 R2