Registered aircraft · 72,010

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.

N6077EAir Fleet Holdings LLC · Addison, TXBuilt 2022 · S/N 2881548 N6077NKrig Marie · Seattle, WABuilt 1969 · S/N M-1202 N6077TStout Joel D DBA · New Cumberland, PABuilt 1979 · S/N 61P07238063350 N6077WParrish Stephen W · Minneola, FLBuilt 1964 · S/N 28-20090 N6077YGreenair Corp · Memphis, TNBuilt 1979 · S/N 61P07258063351 N6078CKtoa Rentals LLC · Torrance, CABuilt 1978 · S/N R18200370 N6078DWagar Dennis Murphy · Marion, MTBuilt 1957 · S/N 22-4732 N6078FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020152 N6078LHott Jack R · Springboro, OHBuilt 1972 · S/N AA5-0178 N60798Hjl Farm Inc · Dagmar, MTS/N 15070587 N6079PColson Carl L · Blunt, SDBuilt 1959 · S/N 24-1177 N6079WAmos Warren E · Cypress, TXBuilt 1964 · S/N 28-20092 N6079YWaller Stephen B · Fairhope, ALBuilt 1992 · S/N 5239 N6079ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-91 N607DCRegistration Pending · Groton, MARegistration pendingBuilt 1991 · S/N 20007 N607DMAdx LLC · Saint Marys, KSBuilt 2002 · S/N T18208138 N607DSNasir Rehan S · Lancaster, PABuilt 2002 · S/N 40.207 N607EABlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1980 · S/N 28-8116140 N607FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916271 N607JWMid-South Bulk Services Inc · West Memphis, ARBuilt 1976 · S/N 32R-7680137 N607KWWalsh Kevin T · Morristown, NJBuilt 1976 · S/N 32R-7680390 N607NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881185 N607PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841215 N607RVGlick Richard A · Mesquite, NVBuilt 2008 · S/N 71916 N607SCN-88xk Medical Aviation LLC · Pittsburgh, PABuilt 2000 · S/N 60163 N6080LBowers Scott · Soddy Daisy, TNBuilt 1972 · S/N AA5-0180 N6080NHuberty Gregory N · Circle Pines, MNBuilt 1969 · S/N M-1204 N6081CShannon Jeanette M · Marathon, FLS/N R18200372 N6081FQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 14681 N6081GFire Master Inc · Tallapoosa, GABuilt 1979 · S/N 61P07478063368 N6081HFlathers George William II · Palmyra, VABuilt 1977 · S/N 28-7890208 N6081NTamim Shekaib · Tracy, CABuilt 1968 · S/N M-1174 N6081UHutchings Zachary A · Clewiston, FLBuilt 1992 · S/N 5267 N6081XCrouch James Doyle Jr · Germantown, TNBuilt 1980 · S/N 61P07558063374 N60823Green Ethan H · San Antonio, TXBuilt 1992 · S/N 5269 N60827Buergel Sandra J · East Aurora, NYBuilt 1993 · S/N 5280 N6082CErvin Eric A · La Follette, TNFirst renewal noticeBuilt 1988 · S/N 5153 N6082NNewberg G Edward · Haines City, FLBuilt 1969 · S/N M-1175 N6082QIrvine Brooklyn L · Sacramento, CABuilt 1965 · S/N 907 N6082RN6082r LLC · Centennial, COFirst renewal noticeBuilt 1980 · S/N 61P07628063378 N6082UWifferdill Inc · Palm Bay, FLBuilt 1991 · S/N 5215 N6082VStewart Glen W III · Lebanon, TNBuilt 1976 · S/N 794 N6083ABilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 18-8009048 N6083JB&R Aircraft LLC · Wadsworth, OHBuilt 1980 · S/N 17273853 N6083LSorensen Paul E Jr · Los Lunas, NMBuilt 1972 · S/N AA5-0183 N6083QAjirogi Michael T · Pearl City, HIBuilt 1965 · S/N 908 N6083USouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 5277 N6083VScholz Francis M · Atchison, KSBuilt 1980 · S/N 172RG0571 N6084CBig Bend Community College · Moses Lake, WABuilt 2008 · S/N 4496267 N6084DCsapos Larry G · Ovid, MIBuilt 1957 · S/N 22-4738

Back to AD 87-10-06 R1