Registered aircraft · 18,495

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N747DWAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH-2002 N747GLoblolly Management LLC · Concord, NCBuilt 1998 · S/N E-3203 N747LJEichleay Peter · Yarmouth, MES/N 0535 N747LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 0496 N747PHFirst State Bancshares Inc · Middleberg, KYFirst renewal noticeBuilt 1988 · S/N TH-1533 N747PJOsprey Capital LLC · Winston Salem, NCBuilt 2005 · S/N 1483 N747SBCloud Transport Operations LLC · Kalispell, MTBuilt 1980 · S/N TJ-297 N747SJBuell Steven M · Fisherville, KYBuilt 2001 · S/N 0091 N747SQYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700387 N747SWJet Air Inc · Iowa City, IAS/N 1370 N747TGValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N 0718 N747TTDogbolter Aviation LLC · Milwaukee, WIBuilt 2003 · S/N 0481 N747VVJk Aero LLC · Altenburg, MOBuilt 1967 · S/N TE-309 N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080 N747YBCarpenter Preston · Wiggins, MSBuilt 2020 · S/N TH-2531 N747YKYk Flight Inc Trustee · Wilmington, DEBuilt 1975 · S/N 310R0138 N747YVGreat Among The Nations Inc · Beverly Hills, CABuilt 1999 · S/N EA-642 N7483QDawson Stewart J · Celina, TXBuilt 1978 · S/N 18503606 N7485CYanover Joseph J · Traverse City, MIBuilt 1974 · S/N 18502373 N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220 N7487Q206 LLC · Anchorage, AKBuilt 1973 · S/N U20602221 N7488NFisher Daniel E · Peyton, COBuilt 1968 · S/N E-38 N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905 N748CDPinkgg LLC · Marathon, FLBuilt 2001 · S/N 0086 N748KPKalinin Partners LLC · Juneau, AKBuilt 1976 · S/N U20603279 N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128 N748WPParker Charles W III · Anchorage, AKBuilt 1967 · S/N 185-1207 N749United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504354 N7491NFarm Systems Inc · Luverne, MNBuilt 1968 · S/N CE-231 N7493NBdm Air LLC · Keller, TXBuilt 1968 · S/N TE-605 N749CDGoat Island Films Inc · Covina, CABuilt 2001 · S/N 0099 N749KPKalinin Partners LLC · Juneau, AKBuilt 1980 · S/N U20605554 N749MRAfterburner Aerospace LLC · Belgrade, MTBuilt 1979 · S/N CE859 N749PGSfly LLC · Dubuque, IABuilt 2005 · S/N 1339 N749RCChadwick Michael · Reston, VABuilt 2004 · S/N 1044 N749RVTime Machine LLC · Kailua Kona, HIS/N U20603480 N749SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606957 N74AGMarion Pilots Club Inc · Marion, INBuilt 2002 · S/N 0428 N74AZHmaair LLC · Gilbert, AZBuilt 1982 · S/N E-2017 N74BPLowell Russell · Vonore, TNBuilt 1973 · S/N E-455 N74BRBbj Aviators LLC · Springfield, ILBuilt 1997 · S/N E-3106 N74BSSanditen Barry A · Austin, TXBuilt 1983 · S/N E-2069 N74BTSta Aviation LLC · Wilmington, DEBuilt 1977 · S/N E984 N74BVGoins Randy E · Pinnacle, NCBuilt 1973 · S/N 74-30635 N74CBKendrick Paul · Atascadero, CABuilt 1974 · S/N D-9690 N74CFWincar Air LLC · Doniphan, NEBuilt 1974 · S/N 18502557 N74CRCage Presnall C · Falfurrias, TXBuilt 2003 · S/N 40061 N74DFRegistered aircraftS/N 18502474 N74DTEnjoy Life Flying LLC · Sunrise, FLBuilt 1999 · S/N EA-634 N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279

Back to AD 86-13-04 R3