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.

N4831SRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1969 · S/N 32-1262 N4831TPower Flow Systems Inc · Daytona Beach, FLBuilt 1972 · S/N 28R-7235120 N4832ESenn David L · Oak Ridge, TNBuilt 1959 · S/N 7GC-40 N4832TVesely Paul T Trustee · Louisa, VABuilt 1981 · S/N R18201772 N4832YStohr Beuford G · Woden, IABuilt 1968 · S/N 25-4626 N48333Central Texas College · Killeen, TXBuilt 1979 · S/N 15283324 N4833LAdbm LLC · Oldsmar, FLBuilt 1967 · S/N 28-4176 N4833PPacifica LLC · Grand Junction, COS/N 27-401 N4833TDodson International Parts Inc · Rantoul, KSBuilt 1972 · S/N 34-7250155 N48340Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15283326 N4834ANicoletti Will · Eagle River, WIBuilt 1956 · S/N 22-3987 N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670 N4834LBell Hubert D · Lewiston, IDBuilt 1967 · S/N 28-4178 N4834SBuell Bay Co · Irvington, VABuilt 1979 · S/N R18201434 N4834ZRoesner David A · Salina, KSBuilt 1961 · S/N 22-8408 N48353Clifton Joshua M · Marion, INS/N 18362 N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383 N4835LSims Kyle Z · Locust Grove, GAS/N 28-4179 N4835SHolder Jamie · Marionville, MOBuilt 1970 · S/N 32-1264 N4835TPero Thomas E · Richland, MIBuilt 1972 · S/N 28-7225218 N48361Love Roger F · East Grand Forks, MNBuilt 1992 · S/N 2527 N4836ASales Joe Haney · Seminole, TXS/N 22-3989 N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384 N4836LPeterson Wayne · Dexter, MNBuilt 1967 · S/N 28-4180 N4836SRegistration Pending · Maple Lake, MNRegistration pendingBuilt 1979 · S/N R18201435 N4836ZDewolfe III Everett C · Cumby, TXBuilt 1961 · S/N 22-8410 N4837FWesellairplanes Com Inc · Wilmington, DEBuilt 1976 · S/N 28-7715071 N4837LNavarro Ricky L · Riverview, FLBuilt 1967 · S/N 28-4181 N4837SJrf Aircraft LLC · Maple Shade, NJBuilt 1969 · S/N 32-1266 N4838Fajardo Mark A · Longmont, COBuilt 1975 · S/N KB-1 N4838BAerolina Inc · Hendersonville, NCBuilt 1979 · S/N 15283665 N4838FThomason Booker T Jr · Chicago, ILBuilt 1976 · S/N 28-7715072 N4838LSandstrom David E · Anchorage, AKBuilt 1967 · S/N 28-4182 N4838SDairy Air LLC · Lake Jackson, TXBuilt 1970 · S/N 32-1267 N4838TSnow Leopard Ltd · Incline Village, NVBuilt 1981 · S/N R18201774 N4838YWagner Nathan D · Dane, WIBuilt 1968 · S/N 25-4634 N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386 N4839LStandard David W · Toccoa, GABuilt 1967 · S/N 28-4183 N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012 N4839ZMacias-Flores Guadalupe · Garden City, KSBuilt 1961 · S/N 22-8413 N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99 N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688 N483EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12254 N483FLOliver Zachary J · Seligman, AZBuilt 1971 · S/N 28-7125291 N483NMCao Roger · Tomball, TXBuilt 2001 · S/N 3250 N483RVCoverstone Timothy L · Bellemont, AZBuilt 2004 · S/N 70175 N483SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 1998 · S/N 172S8029 N48400Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283332 N4840LIrons Eric P · Enoch, UTBuilt 1967 · S/N 28-4186 N4840TRegistered aircraftS/N R18201775

Back to AD 81-18-04 R2