Registered aircraft · 54,015

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.

N6149EOliphant John R · Houston, TXBuilt 1983 · S/N 18268349 N6149KTurbine Financial Group LLC · Ogden, UTBuilt 1976 · S/N R1722029 N6149QGreen Airports Development Corp · Kemah, TXBuilt 1981 · S/N 15285172 N6149SScheller Kenneth R · Glassport, PABuilt 1980 · S/N R18201627 N6149VFoode Frank J · Cordova, AKBuilt 1980 · S/N 172RG0587 N614AZWienholt Robert Jr · Perry Hall, MDBuilt 1985 · S/N 17276475 N614BGNorth Star Aviation Inc · Mankato, MNBuilt 1980 · S/N 15284205 N614MBStarlight Express LLC · Bellevue, WABuilt 1978 · S/N R18200169 N614VZVision Aircraft LLC · Scottsdale, AZBuilt 1981 · S/N 17275258 N614WMCarbonell Terry L · Alva, FLBuilt 1977 · S/N R18200117 N6150ENeedham George T · Seattle, WABuilt 1958 · S/N 46250 N6150FFranklin Aviation LLC · Paradise, CABuilt 1979 · S/N 17273156 N6150GStockton Raymond L · Pearl City, HIBuilt 1969 · S/N 15071650 N6150KAult Greg · Princeton, INBuilt 1976 · S/N R1722030 N6150MJprg Aviation Inc DBA · Orlando, FLBuilt 1980 · S/N 15284631 N6150RChristy David L DBA · Meriden, KSBuilt 1979 · S/N 172RG0095 N6150THaug Michael A · Spring Lake, MIBuilt 1964 · S/N 15060850 N61516Zaikof Bay LLC · Jackson, WYBuilt 1981 · S/N 18504223 N6151BCasey Ross H · Boise, IDBuilt 1957 · S/N 34151 N6151KRomano Aviation LLC · Barrington, RIBuilt 1975 · S/N 15077555 N6151RPath Barney H DBA · Claremont, CABuilt 1965 · S/N T210-0051 N6151SEllis Thomas Troy · Slidell, LAS/N R18201629 N6151UMccall John A · Grapeland, TXBuilt 1985 · S/N 21064914 N6151YBulloch Troy P · Cedar City, UTS/N 21064269 N61522Zipay Michael A · Willow, AKS/N 18504226 N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724 N6152ESkyranch Knoxville Youth Inc · Knoxville, TNS/N 46252 N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052 N6152SN6152s LLC · Sheldon, NDBuilt 1980 · S/N R18201630 N6152VClayton Stephen C · Conyers, GABuilt 1970 · S/N 17258999 N61531Aero Maintenance Inc · Vancouver, WAS/N 17264619 N61534Registration Pending · Cheney, KSRegistration pendingBuilt 1974 · S/N 17264621 N61536Aerolanding LLC · Enterprise, ALBuilt 1974 · S/N 17264622 N61537Coplin Christopher S · Anchorage, AKBuilt 1976 · S/N 18052780 N61539N61539 LLC · Arvada, COBuilt 1974 · S/N 17264624 N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696 N6153RSummers Don · Moose Lake, MNBuilt 1955 · S/N 31820 N6153SDanicic Sinisa · Jacksonville, FLBuilt 1980 · S/N R18201631 N6153ZJaars Inc · Waxhaw, NCBuilt 1981 · S/N U20606162 N61544Knudsen Russell G · East Troy, WIBuilt 1974 · S/N 17264628 N61547Frontline World Missions Inc · Jacksonville, TXBuilt 1974 · S/N 17264630 N61548Adamson Daniel A · Moscow, OHBuilt 1974 · S/N 17264631 N6154BChenoweth Lane Trustee · Anchorage, AKBuilt 1957 · S/N 34154 N6154GGrinnell Matthew J · Auburndale, FLBuilt 1969 · S/N 15071654 N6154NDouer Isaac R · Miami, FLBuilt 1978 · S/N 21062925 N6154QViman LLC · Bear, DEBuilt 1981 · S/N 15285174 N61556Clark William J · Kuna, IDBuilt 1981 · S/N 18504230 N61557Angle Of Attack LLC · Boise, IDBuilt 1975 · S/N 17264638 N6155BPelzer Michael J · Rochester Hills, MIBuilt 1957 · S/N 34155 N6155EShiloh Flying Club Inc · Blandon, PABuilt 1983 · S/N 18268350

Back to AD 87-20-03 R2