Registered aircraft · 18,497

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.

N535VBSchellenger Jonathan H · Port Saint Lucie, FLBuilt 1975 · S/N D-9742 N535WNichols David A · Oneonta, ALBuilt 1965 · S/N D-7897 N535WCMetro West Ambulance · Hillsboro, ORBuilt 1981 · S/N 18504195 N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391 N5365XSale Reported · Greeley, COSale reportedBuilt 1973 · S/N 414-0387 N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394 N5368UBornwasser Louis W · Prospect, KYBuilt 1984 · S/N 21064880 N5369AMartens Charles H · Nokomis, FLBuilt 1979 · S/N 21063395 N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185 N536AMTriniair LLC · Warner Robins, GABuilt 1978 · S/N E1172 N536BBBas Air LLC · Valparaiso, INBuilt 2008 · S/N E-3854 N536EUSarabay Aviation Partners LLC · Sarasota, FLBuilt 2005 · S/N E-3616 N536GSLvhbj LLC · Portola Valley, CABuilt 2011 · S/N E-3948 N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418 N536KEngage Helicopters LLC · Sarasota, FLS/N E3220 N536PSky High II LLC · Clinton, NCBuilt 1998 · S/N E3197 N536TCI C Aviation LLC · Scottsdale, AZBuilt 1988 · S/N EA-481 N536WWright Jack · Fortson, GABuilt 2002 · S/N E-3458 N536WCN8qb LLC · Thief River Falls, MNBuilt 1972 · S/N 21059794 N536WGAdvantage Aviation Inc · Palo Alto, CABuilt 1990 · S/N CE-1446 N5370JJaaam Skyline Inc · Middletown, DEBuilt 1975 · S/N 421B0920 N5370UPogany Steve C · Anchorage, AKBuilt 1979 · S/N U20605251 N5371JColeair LLC · Lewes, DEBuilt 1975 · S/N 421B0921 N5371XMarks Max · Cape Elizabeth, MES/N U20605687 N5372CFlc Aviation LLC · Dyersburg, TNBuilt 1978 · S/N 414A0110 N5372SFlying Solo LLC · Omro, WIBuilt 2004 · S/N 0816 N5378PBlue Skies Today LLC · Eagan, MNBuilt 1974 · S/N U20602492 N5379ABrechtelsbauer Paul · Farmville, NCBuilt 1979 · S/N 21063403 N537CDSullivan Scott W · Sandy, ORBuilt 2005 · S/N 1388 N537DStonebraker Properties LLC · Sierra Vista, AZS/N D-8791 N537SWBingham Leasing Co Lc · Mesa, AZBuilt 1991 · S/N TH-1619 N537VBruno Airways LLC · Fayetteville, GABuilt 2004 · S/N 1009 N5381EMiller Christopher D · Boulder, COBuilt 1979 · S/N 18503959 N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405 N5384WFlitemax Inc · Redondo Beach, CABuilt 2004 · S/N 0854 N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406 N5387HStene Aviation Inc · Polson, MTFirst renewal noticeBuilt 1977 · S/N 18503330 N5388YValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064190 N538BBTextron Aviation Inc · Wichita, KSBuilt 2023 · S/N TH-2538 N538CDBertain Paul · Davis, CABuilt 2005 · S/N 1538 N538NPolk Equipment Inc · Leesburg, INBuilt 2002 · S/N 0308 N5390E402wd Holdings LLC · Robstown, TXBuilt 1979 · S/N 18503961 N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408 N5394XL K Hollenbeak Logging Inc · Hayfork, CABuilt 1980 · S/N U20605710 N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930 N539CDAltmann Michael · Folsom, CABuilt 2004 · S/N 1127 N53AUJoachim Peter · Grafton, WIBuilt 1974 · S/N 340-0356 N53BBWing Bird Aviation LLC · Garland, TXBuilt 1972 · S/N TE-866 N53CWBeitel Theodore C · Higden, ARBuilt 1996 · S/N 96-301024 N53GMOnawa Flying Service Inc · Sioux City, IABuilt 1968 · S/N D-8793

Back to AD 86-13-04 R3