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.

N5449WBlue Skies Aviation Inc · Lowville, NYBuilt 1962 · S/N 28-527 N544AAFriedemann Jon · Manzanita, ORBuilt 2007 · S/N 25572 N544AB544ab Aircraft Leasing LLC · Spanish Fork, UTBuilt 2003 · S/N 10048 N544ARAircraft Registration Inc Trustee · KematenBuilt 1999 · S/N 0025 N544BPLopez Federico Ruiz · Hollywood, FLS/N 34-7250344 N544CAJet Air Inc · Iowa City, IABuilt 1974 · S/N 28-7415206 N544CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881053 N544DADawson Aircraft Inc · Clinton, ARBuilt 2019 · S/N 100 N544DJSouthern Ohio Aviation LLC · Lake Waynoka, OHBuilt 1973 · S/N 28-7415060 N544DLMcwilliams Richard L · Santa Paula, CABuilt 2005 · S/N 10783 N544DRKaranan Corp · Sarasota, FLBuilt 1977 · S/N AA5B-0542 N544HLrh Equipment LLC · Pendleton, ORS/N 335 N544MHHood Helicopters LLC · Longwood, FLBuilt 2000 · S/N 0739 N544NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010013 N544PBPortland Patrol Inc · Lake Oswego, ORBuilt 2001 · S/N 3257238 N544PZAdler Paul D · Chilmark, MABuilt 1973 · S/N 17701981 N544RLPlane Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1384 N544SABlack Ops Asphalt LLC · Kingsport, TNBuilt 2006 · S/N 11145 N544SBHd Aviation Services LLC · Pembroke Pines, FLBuilt 2007 · S/N 1759 N544SHAg Farmacy Applications LLC · Erie, ILBuilt 2005 · S/N 10818 N544SWCatherine Michaels Investment Services LLC · Carlsbad, CABuilt 2000 · S/N 2843388 N544TAWright Richard L Jr · Flower Mound, TXBuilt 1973 · S/N 28-7305455 N544TGKavalair LLC Series C · Marion, MTBuilt 2006 · S/N 11177 N544WBCharlie Foxtrot Airworks LLC · Jacksboro, TXBuilt 1997 · S/N 21544 N544WMCampbell Greg L · Greenville, WIBuilt 2012 · S/N 3358 N54502Ho Simpson S · Poway, CABuilt 1981 · S/N 17274991 N5450EMiller Byron W · Silverton, ORS/N 2507 N5450FN5450f LLC · Fernandina Beach, FLBuilt 1976 · S/N 28-7790126 N5450HLima-001 LLC · Muscatine, IABuilt 1975 · S/N 17265446 N5450LNorman Craig Gentry · Brenham, TXBuilt 1973 · S/N AA5-0350 N5450PRegistration Pending · Sun Lakes, AZRegistration pendingBuilt 1958 · S/N 24-505 N5450WChambers Kirk · Delta, OHBuilt 1962 · S/N 28-528 N5451FVirginia Aviators LLC · Sterling, VABuilt 1976 · S/N 32R-7780011 N5451KSkywarior Flight Training Inc · Pensacola, FLBuilt 1980 · S/N 17274117 N5451LSymond Christopher M · Riverton, UTS/N AA5-0351 N5451WAndre Craig W · Pierre, SDBuilt 1962 · S/N 28-529 N5452KAviation Club LLC · Sussex, NJBuilt 1980 · S/N 17274118 N5452PLewis Nathan W · Vale, ORBuilt 1958 · S/N 24-508 N54531Jordan Alex N · Clarkton, NCBuilt 1981 · S/N 17274995 N5453KDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 17274119 N5453LTwo Tracts LLC · Sheridan, WYBuilt 1973 · S/N AA5-0353 N5453PNoel Andrew F Jr · Morton, WABuilt 1958 · S/N 24-509 N5453TSale Reported · WeidenSale reportedBuilt 1982 · S/N R18201870 N5453WWheeler Dale · Valencia, CAS/N 28-531 N5454KGolden Mahalo LLC · Sheridan, WYBuilt 1980 · S/N 17274120 N5454LCarboneau Luke M · Las Cruces, NMBuilt 1973 · S/N AA5-0354 N5454PRio Grande Flying Association Inc · Center, COBuilt 1958 · S/N 24-510 N5454YMatthews Grover · Fairborn, OHBuilt 1964 · S/N 27-2539 N5455EHaddix Christopher W · Chugiak, AKS/N 2512 N5455HMiller Michael R · Portage, MIBuilt 1975 · S/N 17265449

Back to AD 87-10-06 R1