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.

N4261JMathison John M · Vancouver, WABuilt 1967 · S/N 28-22618 N4262Regal Dent Inc · Goshen, NYFirst renewal noticeBuilt 2006 · S/N 2843647 N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105 N4262HNorthern Iowa Anesthesia Services P L C · Ames, IAS/N 24-0688 N4262JBeaverdam Aeronautics LLC · Chatom, ALS/N 28-22619 N4262MHoech Neal L · Everett, WABuilt 1947 · S/N 12-3175 N4262PPower Willis H · Weatherford, TXS/N 23-1761 N42632Hebert Mark R Trustee · Lakeville, MNBuilt 2022 · S/N 18283184 N4263HSchneider Michael J · Anchorage, AKBuilt 1948 · S/N 14-67 N4263JBmf Wings LLC · Corinth, MSBuilt 1967 · S/N 28-22620 N4263MThompson Frank Link · Gordon, NEBuilt 1947 · S/N 12-3178 N4263ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 18-8493 N4264DKnisely Kevin R · Lapeer, MIBuilt 2000 · S/N 27002C N4264FNack Kim R · Wentzville, MOBuilt 1994 · S/N 1030 N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4264TSmith John W · Cold Spring, NJBuilt 1972 · S/N 28-7205124 N4264ZAllen Steven L · Thatcher, AZBuilt 1967 · S/N 18-8507 N4265HAngel Aviation Inc · Peoria, AZBuilt 1948 · S/N 14-69 N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4265ZBaklarz Ralph B · Eagle River, AKBuilt 1967 · S/N 18-8508 N4266BCarpenter Steven Warren · Inver Grove, MNBuilt 2000 · S/N 26009C N4266JMarvin Carlton R · Tomahawk, WIBuilt 1967 · S/N 28-22623 N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166 N4266ZVan Ryzin Chris K · Sterling, AKBuilt 1967 · S/N 18-8512 N42671P&N Corp · Marion, IABuilt 1974 · S/N 28-7415398 N42675908 Flying Club Inc · Fort Pierce, FLBuilt 1974 · S/N 28-7405165 N42677Swank And Son Inc · Poplar, MTBuilt 1975 · S/N AA5B-0074 N4267ERmd Enterprises LLC · Rockwall, TXBuilt 1978 · S/N 38-78A0515 N4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeBuilt 1978 · S/N 24-0690 N4267MMurphy Aaron S · Girdwood, AKBuilt 1947 · S/N 12-3196 N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167 N4267THooley Charles M · North Oaks, MNBuilt 1971 · S/N 28-7225110 N4267YKragel Robert J · Atascadero, CABuilt 1982 · S/N DK-1 N4268FWindt Edward A Jr · Chester, NJS/N 28-7790008 N4268JLuxair LLC · Van Nuys, CAS/N 28-22626 N4268PAhlem Mark · Hilmar, CABuilt 1959 · S/N 23-1767 N4269HSiniakin Michael K · East Brunswick, NJBuilt 1978 · S/N 24-0692 N4269JMasino John B Jr · Berlin, MDBuilt 1967 · S/N 28-22628 N4269TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1972 · S/N 28-7205126 N4269UAero380 Corp · Wilmington, DEBuilt 2017 · S/N 30021 N426CPCivil Air Patrol · Montgomery, ALBuilt 2001 · S/N 172S8688 N426CTAir Kraft Aviation LLC · Timber Lake, SDS/N 11174 N426CUMiller Justin S · Cedar Rapids, IABuilt 2021 · S/N 4261986 N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827 N426ESWeaver Corey E · Saline, MIBuilt 1997 · S/N 17280263 N426HHickerson Timothy William · Springfield, OHBuilt 2003 · S/N 81246 N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050 N426JGAero Flight School No7 LLC · Lincoln Park, NJBuilt 2008 · S/N 172S10862 N426JMThompson Daniel · Catawba, NCBuilt 1999 · S/N 60191

Back to AD 81-18-04 R2