Registered aircraft · 54,017

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N4673FCody Richard A · Mclean, VABuilt 1966 · S/N P206-0273 N4673NSimla Properties LLC · Casa Grande, AZBuilt 1979 · S/N 18266848 N4673UStephl Chris L · Soldotna, AKBuilt 1964 · S/N 18051372 N4673XRegistration Pending · Bloomingdale, OHRegistration pendingBuilt 1966 · S/N 15064723 N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463 N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464 N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465 N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466 N46748Roscioli Lamberto · Lighthouse Point, FLBuilt 1978 · S/N 15283098 N4674CN&C Enterprises LLC · Vine Grove, KYBuilt 1953 · S/N 25618 N4674EMilliken Bradley B · San Mateo, CABuilt 1982 · S/N 18268258 N4674SDirect Oscar LLC · Jamestown, NYS/N R18201376 N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802 N4674XSaunders Christopher · Lehighton, PABuilt 1966 · S/N 15064724 N4675CLane Robert W · Palmer, AKBuilt 1974 · S/N 18502592 N4675ERojo Aircraft LLC · Mesquite, NVBuilt 1982 · S/N 18268259 N4675XBlalock Merrel K III · Mayflower, ARS/N 15064725 N46762Kay Bennie L · Brigham City, UTBuilt 1978 · S/N 15283102 N4676BRobbins J Putnam · Valparaiso, INBuilt 1955 · S/N 31574 N4677CRegistered aircraftBuilt 1953 · S/N 25621 N4677LJet Airways Express Inc · Aventura, FLBuilt 1966 · S/N 17254672 N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577 N4677XBaird Harvey L · Sharon, OKFirst renewal noticeS/N 15064727 N4678BKing Paul E · Albany, ORBuilt 1955 · S/N 31576 N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278 N4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1975 · S/N 18263679 N4678QPrairie Dog Aviation LLC · Sioux Falls, SDBuilt 1972 · S/N 21059578 N4678TRothberg Diane Lee · Gainesville, GABuilt 1981 · S/N R18201730 N4679AFlying Bulldogs LLC · Joplin, MOBuilt 1956 · S/N 32276 N4679CDahl Dan P · Wasilla, AKBuilt 1953 · S/N 25623 N4679GFlightime Inc · Elkhart, INS/N 17273305 N4679LFitting Solutions Lc · Chester, NJBuilt 1966 · S/N 17254674 N4679UNelson Ross R · Menomonie, WIBuilt 1964 · S/N 18051379 N4679XVentura Joel · Andover, MABuilt 1966 · S/N 15064729 N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983 N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879 N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142 N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475 N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649 N46803Ken Graham Phd Inc · Sioux Falls, SDBuilt 1979 · S/N 15283108 N4680KIntrepid Red Baron Inc · New Franken, WIBuilt 1975 · S/N 18263681 N4680LWasilowski Steven P · Elgin, ILBuilt 1966 · S/N 17254675 N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814 N4680UFoster Randy · La Grange, TXBuilt 1964 · S/N 18051380 N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281 N4681KBluestone Ryan Joseph · Lake Havasu City, AZBuilt 1975 · S/N 18263682 N4681LOmer Syeda · Gilroy, CAS/N 17254676 N4681SRezek William E · Centennial, COBuilt 1979 · S/N R18201377 N4681ZWhite Blaine Scott · Castlewood, VABuilt 1980 · S/N 32278 N46826Registration Pending · Tampa, FLRegistration pendingBuilt 1979 · S/N 15283114

Back to AD 87-20-03 R2