Registered aircraft · 72,001

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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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:87-10-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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.

N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145 N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509 N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011 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 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 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 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 N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N2140RStidham Stephen A · North Pole, AKBuilt 1989 · S/N 01 N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162 N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340 N2140WAbbott Bruce E · Seal Beach, CABuilt 1974 · S/N M-1513 N2140YNorcal Flight Club · Vacaville, CABuilt 1979 · S/N 28-7916372 N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044 N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045 N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273 N21418Woodard Christopher Shane · Forney, TXBuilt 1978 · S/N 32-7840185 N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297 N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221 N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734 N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302 N2141THorizon Ventures Inc · Red Oak, IABuilt 1971 · S/N 28R-7135144 N2141WMeyer Carl F Jr · Eagan, MNBuilt 1974 · S/N M-1514 N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207 N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469 N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224 N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089 N2142YChanfrau Frederic · Barrington, RIS/N 28-7911142 N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210 N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211 N21438Texas State Technical College · Waco, TXBuilt 1979 · S/N 44-7995051 N2143AUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 44-7995085

Back to AD 87-10-06 R1