Skip to content

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.

N864AKNorthern Waters LLC · Livingston, MTBuilt 1980 · S/N 18504066 N864CMForss Jamey L · Ferndale, WABuilt 1979 · S/N 340A0683 N864JBBas Part Sales LLC · Greeley, COBuilt 1986 · S/N 4608009 N8650ZBarry Russell L · Fort Mohave, AZBuilt 1967 · S/N P206-0450 N8652KDelta Charlie Company LLC · Billings, MTS/N 340A0606 N8652RFour Alpha Juliet LLC · Minster, OHBuilt 2000 · S/N E-3354 N8654QSpitler Cynthia D · Maryville, TNBuilt 1964 · S/N D-7667 N86567Ireys Charles G · Tok, AKBuilt 1976 · S/N 18503128 N8657QSchmidt Jack R · Chagrin Falls, OHBuilt 1964 · S/N D-7738 N8658QHarris Austin K · Enid, OKBuilt 1964 · S/N D-7673 N8659QAlexander Harold W Trustee · West Richland, WABuilt 1979 · S/N 18503755 N865MCN865mc LLC · Knoxville, TNBuilt 1973 · S/N TE 905 N8662QGrant Aviation LLC · Cheyenne, WYFirst renewal noticeBuilt 1964 · S/N D-7672 N8665QMojo Aerospace LLC · Wilmington, DEBuilt 1964 · S/N D-7676 N8666VFriedman Michael S · Chantilly, VAFirst renewal noticeBuilt 1965 · S/N D-7832 N8667QNerstrom James S · Libertyville, ILBuilt 1964 · S/N D-7679 N8668QFrequent Flyers LLC · Kalispell, MTS/N D-7682 N866CApus Aviation Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0397 N866CSGlobal Air Concepts LLC · Anchorage, AKBuilt 1975 · S/N 18502866 N866DLHenry Kelly L · Meridian, IDBuilt 1973 · S/N 74-30623 N866PHPhobos 185 LLC · Cody, WYFirst renewal noticeBuilt 1977 · S/N 18503167 N866RAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N EA-105 N8670GRegistration Pending · Williams, AZRegistration pendingBuilt 1977 · S/N 310R0949 N8671KFlight Unlimited LLC · Dover, DEBuilt 1978 · S/N 340A0611 N8674QHalasi Kun David L · Suffield, CTBuilt 1964 · S/N D-7683 N8674ZHoch Lance M · Weiser, IDBuilt 1968 · S/N P206-0474 N8675KJjjp North LLC · New London, NCBuilt 1978 · S/N 340A0614 N8677QLittle Lady Inc · Wilmington, DEBuilt 1964 · S/N D-7684 N8678QProffitt Perry Vaughn · Roanoke, TXBuilt 1964 · S/N D-7681 N8679QEagle Flight Services LLC · Lake Oswego, ORS/N D-7687 N867CBKmr Air LLC · Bonita Springs, FLBuilt 2015 · S/N E-4057 N867CDMoonset Ranch LLC · Missoula, MTBuilt 2002 · S/N 0195 N867LCCurd Layton · Cypress, TXBuilt 1991 · S/N E-2649 N867SSixty Seven Sierra LLC · Wilmington, DEBuilt 1969 · S/N D-8957 N8682QNoguess Levi B · Belton, TXBuilt 1964 · S/N D-7696 N8684QBush Mark B · Crosby, TXBuilt 1964 · S/N D-7688 N8686QWaters & Associates Inc · Bellaire, TXS/N U20603468 N8687QWhite Thomas B · Long Beach, CABuilt 1964 · S/N D-7694 N8688ZPowell Leo · Villa Park, CAS/N P206-0488 N868CTPrivette Hugh T Trustee · Colorado Springs, COBuilt 1974 · S/N 74-30726 N868JFTrax Aviation LLC · Northport, ALBuilt 2008 · S/N E-3868 N8690QWallek Dustin L · Corpus Christi, TXBuilt 1964 · S/N D-7700 N8693QFester John P · Sullivan, MOBuilt 1964 · S/N D-7703 N8694QBonkowski & Associates Inc · Emeryville, CABuilt 1964 · S/N D-7704 N8695MGround Floor Design LLC · Idyllwild, CABuilt 1964 · S/N D-7336 N8697QPas Aviation Inc · Modesto, CABuilt 1965 · S/N D-7768 N8699QSmith Sidney R Trustee · Rllng Hls Est, CABuilt 1964 · S/N D-7692 N8699ZEdaero LLC · Bangor, MEBuilt 1968 · S/N P206-0499 N869KSUniversity Of Central Missouri · Warrensburg, MOBuilt 1993 · S/N TH-1692 N86AGGarlow Terry J · Granbury, TXBuilt 1975 · S/N 21060966

Back to AD 86-13-04 R3