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.

N222SPRobinson Avery Clark · Phoenix, AZBuilt 1965 · S/N 701 N222TJSimmons Scott C · Pleasant Prairie, WIBuilt 1979 · S/N 28-7911314 N222TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1981 · S/N 18-8109081 N222TRHarper David E · Stillwater, MNBuilt 1946 · S/N 108-322 N222UClukey David Alan · Bryant Pond, MEFirst renewal noticeBuilt 1957 · S/N 23-912 N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491 N222VBGalaxy Aviation LLC · Nantucket, MAS/N 10009 N222VWCool Beans LLC · Newtown, PAS/N 18280085 N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443 N222WBPower Robert R · Brenham, TXBuilt 1968 · S/N 27-3992 N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092 N222WPFord Scott S · Punta Gorda, FLBuilt 1974 · S/N E-516 N222XPMarshall Greg J · Alexandria, VABuilt 2021 · S/N 102 N222ZMPresentation Impact LLC · Sandia Park, NMBuilt 1990 · S/N 4622115 N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189 N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374 N22316Mcleland David L · Sellersburg, INBuilt 1999 · S/N 27-0276 N2231JWares Auto Sales Inc · Traverse City, MIBuilt 1978 · S/N 32R-7985053 N2231MGreat Lakes Aviation Services Inc · Kimball, MIS/N 32-975 N2231XCaselato Andre Luiz Puls · Kissimmee, FLBuilt 2000 · S/N 27-0296 N2232Reigle Aviation · Palmyra, PABuilt 1971 · S/N 1-GP N22320B Lillico Petroleum Consultants Ltd · Eastport, IDBuilt 2000 · S/N 27-0297 N2232ASummit Air LLC · Clarks Summit, PABuilt 1976 · S/N 28-7690460 N2232BLucky Dog Land Co LLC · Caldwell, IDBuilt 1990 · S/N 512 N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195 N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819 N2232NKnoll Guenter Wilhelm · Belton, SCBuilt 1979 · S/N 28-7990283 N2232QStender Michael L · Davenport, IABuilt 1979 · S/N 28-7911106 N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334 N2232ZAlaverdi Omeed · California, MDBuilt 1976 · S/N 76-31135 N22336Goldshlager Benjamin · Boca Raton, FLBuilt 1978 · S/N 28-7911004 N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598 N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147 N2233LBecker Leo Henry · Leavenworth, KSBuilt 1979 · S/N 32-7940028 N2233MPutnam John P · Weirsdale, FLS/N 18280069 N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842 N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368 N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207 N2234PDanhauer Jeffrey · Owensboro, KYBuilt 1974 · S/N 761-74 N2234UMountain States Casing Co LLC · Timnath, COBuilt 2006 · S/N T18208485 N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120 N2235CAnderson Nick A · Cynthiana, KYBuilt 1978 · S/N 28-7911024 N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198 N2235LCarter Dale · Riga, MIBuilt 1976 · S/N M-1905 N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844 N22363Barnes Welding Inc · Waterville, WABuilt 1978 · S/N 32R-7887258 N2236CAlexander James E Jr · Fort Worth, TXBuilt 1978 · S/N 28-7911025 N2236GParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916215 N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845 N2236UPrater Jon A · Palm Coast, FLBuilt 1967 · S/N 475

Back to AD 87-10-06 R1