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.

N41477Shepro Scott M · Senoia, GABuilt 1974 · S/N 28-7405107 N4147EEnglerth Mark J · Wasilla, AKBuilt 1978 · S/N 18-7809086 N4147GStinson Aaron M · Anchorage, AKFirst renewal noticeBuilt 2000 · S/N 28-43364 N4147KUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843169 N4147NGeorge Robert J · Natick, MABuilt 1999 · S/N 3246131 N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272 N4147YReisdorf Steven R · Saint Cloud, MNBuilt 1976 · S/N 956-76 N4147ZHopper Bruce · Chugiak, AKBuilt 1965 · S/N 18-8225 N41480Tradewind Aviation Co Inc · Blue Bell, PABuilt 1999 · S/N 3246147 N41482Cannella Ingrid D · Pineville, LABuilt 1974 · S/N 28-7415231 N41484Ferraro Jeffrey T · Mckinney, TXBuilt 1999 · S/N 4636234 N4148CMjolhus Knut G · Amarillo, TXBuilt 1978 · S/N R18200329 N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170 N4148EDoody Michael C · Knoxville, TNBuilt 1978 · S/N 18-7809087 N4148HRegistered aircraftBuilt 1978 · S/N 24-0647 N4148TChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496027 N4148UFlightline Helicopters Inc · Cave Creek, AZFirst renewal noticeBuilt 2008 · S/N 4290 N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76 N4148ZWillet Gerald E · Townsend, MTBuilt 1965 · S/N 18-8227 N4149Huish Aaron Leo · Mesa, AZBuilt 1969 · S/N 01010 N41497Bagley Russell L · Frankston, TXBuilt 1974 · S/N 28-7425249 N41498G&M Aircraft Inc · Wheat Ridge, COBuilt 1974 · S/N 28-7415237 N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189 N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190 N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191 N4149JElko Aviation Group LLC · Elko, NVBuilt 1966 · S/N 28-22474 N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192 N414BCRoche Robert C · Casa Grande, AZBuilt 1965 · S/N 28-21129 N414DEdgewater Aviation LLC · Lake Havasu City, AZBuilt 1999 · S/N 460 N414DJSuper Tiger LLC · New York, NYBuilt 1979 · S/N AA5B1298 N414EBRegistration Pending · Carson City, NVRegistration pending, pending cancellationS/N 128 N414ERRegistration Pending · Wilmington, DERegistration pendingBuilt 2017 · S/N 172S12026 N414FHSewell Stephen A · Navasota, TXBuilt 1980 · S/N R18201639 N414JRGunderson Milton J · Mora, MNBuilt 1996 · S/N 1431 N414LGElite Fleet LLC · Spofford, NHBuilt 2006 · S/N 817-320-659 N414LJRegistered aircraftBuilt 1971 · S/N 102M N414MEEight Ball Flying Club Inc · Van Nuys, CABuilt 2000 · S/N 18280865 N414PPlane Racing III LLC · Chandler, AZBuilt 1989 · S/N 3053 N414PKTakeoff Properties LLC · Belmont, NCBuilt 2023 · S/N 18283243 N414PMKnaub Samuel S · Fairbanks, AKBuilt 2010 · S/N 001 N414RMMutzman Richard C Trustee · Dublin, OHBuilt 1979 · S/N AA5B1313 N414RVProebstl Robert J · Torrance, CABuilt 2004 · S/N 4180 N414SJBradley Scott · Manassas, VABuilt 2008 · S/N 5913 N414TBTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13494 N414USJohnson Lawrence F · Anchorage, AKBuilt 2014 · S/N 41 N414UTRoth Colin E · Anchorage, AKBuilt 1982 · S/N 7408C N414VTSnellmeyer Aviation LLC · Murrieta, CABuilt 1977 · S/N 28R-7737104 N414WMChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 2844110 N414WWWillmott Webb B · Jackson, MSBuilt 2024 · S/N 81583 N41500Brandt Benjamin C · Nampa, IDBuilt 1989 · S/N 1809011

Back to AD 81-18-04 R2