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.

N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685 N44JKKirkman Todd · Chetek, WIS/N CE-102 N44KCSpitfire Ix Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2003 · S/N 0516 N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598 N44KRMcilhenny Edward A · Clayton, GABuilt 1983 · S/N EA-358 N44MPMiller Dennis Joseph · Bartlett, TNBuilt 1969 · S/N TE-760 N44NKNist Joseph Anthony II · Pittsburgh, PABuilt 1968 · S/N TE-470 N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531 N44PBMcpeck Adam S · Agar, SDFirst renewal noticeBuilt 1964 · S/N D-7678 N44PZRegistered aircraftBuilt 1998 · S/N 29-0135 N44SAGniks LLC · Nevada, MOBuilt 1978 · S/N TJ-167 N44SBReid Larry Paul · Jasper, GABuilt 1971 · S/N CE-356 N44SCAir Charter Solutions Inc · Bloomington, MNFirst renewal noticeBuilt 1969 · S/N 421A0101 N44SPAwh Ventures Inc · Houston, TXBuilt 1975 · S/N TE-1036 N44TEThomaston Bonanza Club Inc · Thomaston, GABuilt 1975 · S/N E-796 N44TLEco-Logic Environmental Engineering Inc · Placentia, CABuilt 1979 · S/N 80-30973 N44TUOglesby John B · Graford, TXBuilt 1978 · S/N 18503616 N44VBColeman Jack L · Monroe City, MOBuilt 1978 · S/N CE-760 N44VKBates Management Inc · Woodstock, GABuilt 1979 · S/N 310R1689 N44WFWildy David · Manila, ARBuilt 2003 · S/N 0533 N44WHKelly Sean R · Bozeman, MTS/N 21061316 N44WXA O Retail Consulting Inc · Oconomowoc, WIBuilt 2005 · S/N 1258 N44XJRegistered aircraftBuilt 1984 · S/N TJ-478 N44YHansen Kenneth · Irvine, CAS/N G-760 N44ZMSchnurbusch Larry · Saint Louis, MOBuilt 1978 · S/N E-1279 N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201 N4503SBarber Christian · Mansfield, MABuilt 1975 · S/N CE-594 N4504SRegistered aircraftBuilt 1975 · S/N E-720 N4505SGo Flyers LLC · Sudbury, MABuilt 1975 · S/N CE-596 N4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTBuilt 1974 · S/N 18502576 N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795 N4507FRodriguez Kenneth C · East Wenatchee, WABuilt 1966 · S/N 185-0989 N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741T N450CDAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N 1478 N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214 N450JRNowell Borders Lp · Edinburg, TXBuilt 1975 · S/N TH-670 N450THHk Air LLC · Byron, GABuilt 1981 · S/N TH-1298 N450TXM And M Aviation Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1063 N450WSMatter Donald Chad Trustee · Friendswood, TXBuilt 1979 · S/N E-1552 N450YRSmith John W Jr · Stamps, ARBuilt 1981 · S/N CE-978 N4513MLeopold Aero LLC · Wilmington, DEBuilt 1978 · S/N TE-1127 N4515MCooper Steve O · Phoenix, AZBuilt 1978 · S/N CE-767 N4515SHarris Aviation LLC · Texarkana, TXBuilt 1975 · S/N E-725 N4516SConcepcion Carlos L · Pembroke Pines, FLBuilt 1975 · S/N TE-1057 N4519SBlanck Greg J · Redwood City, CABuilt 1975 · S/N E-719 N451LXBassen Gerald R · Saint George, UTBuilt 2025 · S/N LIV-250 N451STrevathan Max Tyler · Dyersburg, TNBuilt 1977 · S/N E1200 N451SBModleski Matthew · Noblesville, INBuilt 1978 · S/N TH-897 N451TJSr22 Aviators LLC · Crete, ILBuilt 2004 · S/N 0866 N4520FRegistered aircraftBuilt 1966 · S/N 185-1005

Back to AD 86-13-04 R3