Registered aircraft · 81,720

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.

N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368 N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N2137FColakoglu Migirdic · Hilton, NYBuilt 1978 · S/N 28-7911048 N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205 N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138AKingdom Air Corp · Sutton, AKBuilt 1952 · S/N 18-1859 N2138NJ T Air Inc · Dayton, MDBuilt 1979 · S/N 28-7911094 N2138PRedwood Barry Lindon · Forest, VABuilt 1956 · S/N 23-729 N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646 N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561 N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449 N2139AAero Seat Inc · Sterling, COBuilt 1952 · S/N 18-1861 N2139BN2139b LLC · Newark, DEBuilt 1978 · S/N 28-7911009 N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220 N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145 N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448 N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509 N213AMNorton Cole R · Marion, IAS/N 559-73 N213AZHardcastle Kenny W · Caulfield, MOBuilt 2018 · S/N 90277 N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056 N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147 N213CDJungman Frank · Escondido, CABuilt 2000 · S/N 1111 N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046 N213CRJuarez Justin · Garden City, IDBuilt 1992 · S/N 690-92 N213CSAeromarine Airways Inc · Miami, FLBuilt 1978 · S/N 24-0529 N213DSLexington Flying Club Inc · Lexington, KYBuilt 2004 · S/N 40.360 N213EZOff Road Freedom Jr LLC · Walled Lake, MIS/N 101 N213GDEdal Inc · Plantation, FLBuilt 1978 · S/N AA1C0145 N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130 N213HTValdovinos Candido · Monroe, WABuilt 1968 · S/N 67-16822(780929)N213JMHagleitner Gunther · San Jose, CABuilt 1999 · S/N 22651 N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312 N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282 N213MKKwiatkowski Matthew A · Minooka, ILBuilt 2008 · S/N 213 N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572 N213PMainstream Aviation LLC · Benton, KYBuilt 2022 · S/N 3390 N213SALatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1973 · S/N 28R-7435138 N213SFSeaton Flying Services · Killeen, TXBuilt 2005 · S/N 1534 N213SMArrowhawk Imaging LLC · Morgantown, WVBuilt 2003 · S/N 20608206 N213TFlemmer Richard W · Park City, MTBuilt 1953 · S/N 18-2327 N213TCL W Logsdon Corp Inc · Toledo, OHBuilt 1983 · S/N 213 N213TJNewsome Timothy S · Alta Loma, CABuilt 2020 · S/N 2B-3B/4B-1437B N213WTCarmer Jacob D · Mount Morris, MIBuilt 1993 · S/N 1359 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N2140ALloyd Davis Inc · Brackettville, TXBuilt 1952 · S/N 22-572 N2140HLindeman Jeff · Archer City, TXBuilt 2008 · S/N S1919 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018

Back to AD 81-18-04 R2