Registered aircraft · 81,728

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.

N2381ZLeone Brighter Developments LLC · Carlsbad, CABuilt 2005 · S/N 17281276 N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999 N2382DPerry Donald A · Colleyville, TXBuilt 1999 · S/N 18280471 N2382EGore Group LLC · Eagle Pass, TXBuilt 1999 · S/N 18280472 N2382HWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280473 N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222 N2382RTampa Bay Aviation Inc · Clearwater, FLBuilt 1999 · S/N 17280700 N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031 N2382VAnywhere Atp LLC · Mount Juliet, TNBuilt 1982 · S/N 38-82A0061 N2382YBarnwater Development Inc · Ardmore, OKBuilt 1998 · S/N 18280380 N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002 N2383FLaminar Aerospace LLC · Waukegan, ILBuilt 1978 · S/N 38-79A0411 N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774 N2383WMcclure Miles · Vancouver, WAS/N MB-18 N23841Lam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 17280710 N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342 N2384LChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280706 N2384MDiedrich Steve · Sandpoint, IDS/N 12-1510 N2384PLarsen Steve J · Colton, ORS/N 22-2775 N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464 N2384RMonroe Joel L · Alexandria, MNBuilt 1971 · S/N 28-7110003 N2384UMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280708 N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184 N23851Giordano Kim O · Foxboro, MABuilt 1978 · S/N M-2006 N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811 N2385ADevries Myles · Cut Bank, MTBuilt 1952 · S/N 22-750 N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172 N2385FAlpha Aviation Inc · Mount Vernon, WAS/N 17280714 N2385KHaynes Vincent L · Maumelle, ARBuilt 1979 · S/N 38-79A0610 N2385MLucatorto Jeffrey A · Mc Gaheysville, VABuilt 1946 · S/N 12-1627 N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064 N2385YSpeedboat Photo Helicopter LLC · Rehoboth Beach, DES/N 0538 N2385ZStacy Rick A · Arlington, OHBuilt 2016 · S/N 70554 N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173 N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261 N2386MHoeffler James P · Fort Collins, COBuilt 1946 · S/N 12-1628 N2386NHoelzle Paul R · Fremont, OHS/N 38-79A0820 N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602 N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065 N2386VEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 17280702 N2386ZHoffman Kurt T · Savannah, GABuilt 1962 · S/N M-109 N2387BMacken Inc Corp · Saint Paul, MNBuilt 1948 · S/N 3687 N2387KClipper Properties LLC · Saratoga, WYBuilt 1979 · S/N 38-79A0833 N2387MOlson Catherine R · Two Rivers, AKBuilt 1946 · S/N 12-1630 N2387SWittkop Joseph D · Dillingham, AKBuilt 1979 · S/N 18-7909142 N2387UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280721 N2388BN2388b LLC · Salem, ORBuilt 1978 · S/N 38-79A0031 N2388MVotaw Kristina M · Anchorage, AKBuilt 1947 · S/N 12-1631 N2388TSlatner John W · Sims, NCBuilt 1978 · S/N 38-78A0787 N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188

Back to AD 81-18-04 R2