Skip to content

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.

N701PSLucky US LLC · Merrill, WIBuilt 1977 · S/N 21062339 N701SGMach Aviation LLC · Ocklawaha, FLBuilt 2004 · S/N 0963 N70200Stephl Matt J · Anchorage, AKBuilt 1972 · S/N 18502053 N70206Hayton James B · Sedro Woolley, WABuilt 1972 · S/N 18502057 N7020NRanchn Air LLC · Fort Collins, COBuilt 1967 · S/N TE-468 N70219Ellis James F · Wasilla, AKFirst renewal noticeBuilt 1972 · S/N 18502063 N7021NRobertson Eric A · Knoxville, TNBuilt 1967 · S/N D-8620 N70221Greer Charles R · Chugiak, AKBuilt 1972 · S/N 18502065 N7022GSamarth Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0695 N70231Low Level Aero LLC · Myakka City, FLBuilt 1974 · S/N 18801873T N70233Morris Gray S · Chugiak, AKBuilt 1972 · S/N 18502075 N7023NSteria Kermit J · Monahans, TXBuilt 1967 · S/N D-8627 N70248L C Hanson Co Inc · Clancy, MTBuilt 1972 · S/N 18502080 N70253Claus Jay G · Palmer, AKBuilt 1972 · S/N 18502082 N70279Sh Th LLC · Miami Beach, FLS/N ES-159SFB N70288Dakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801879T N702DDJoyce Consulting LLC · Black Hawk, SDBuilt 1999 · S/N EA-644 N702DLBohlke LLC · Kingshill, VIBuilt 1966 · S/N TE-136 N702DSYaviation LLC · Burns, TNBuilt 2004 · S/N 0989 N702DZSkydive Fargo Inc · West Fargo, NDBuilt 1966 · S/N P206-0152 N702FCFlight Inc · Concord, NCBuilt 2001 · S/N 0018 N702JKAlpha Whiskey Air Company LLC · Richardton, NDBuilt 1979 · S/N TH-1009 N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672 N70326Triple E Farms LLC · Peculiar, MOBuilt 1974 · S/N 18801887T N7032QRegistration Pending · Oakwood, OHRegistration pendingBuilt 1976 · S/N U20603067 N70333Northland Aircraft Sales LLC · Fairbanks, AKBuilt 1972 · S/N 18502115 N70341Michels LLC · Wasilla, AKBuilt 1972 · S/N 18502119 N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49 N70350Bigwings Ag Inc · Delavan, MNS/N 18801895T N70358Mcgugin Donald W · Anacortes, WAS/N 18502129 N7037EHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0471 N70387Becker Flying Service Inc · Hartington, NEBuilt 1974 · S/N 18801905 N70391Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502144 N703JMToller Kevin K · Broken Arrow, OKBuilt 1971 · S/N E-278 N703NCNunn Bryant · Canton, MIBuilt 1972 · S/N TH-224 N703THall Charles M · Lubbock, TXBuilt 1975 · S/N D-9816 N70403Mccormick Eugene C DBA · Tyler, ALBuilt 1974 · S/N 18801912T N70438Sneller Heath E · Annandale, MNBuilt 1973 · S/N 18502170 N7044NExplore Lake Lure LLC · Miami, FLBuilt 1967 · S/N TE-472 N7045NIndy Air Sales LLC · Anderson, INBuilt 1967 · S/N D-8633 N70462Alis Russell D · Fairbanks, AKBuilt 1973 · S/N 18502178 N70468Poschwatta Jeffrey R · Kent, WAS/N 18502182 N7046NMoore John Robert III · Lusby, MDBuilt 1967 · S/N D-8634 N70487Picazo Daniel M · Rogersville, TNBuilt 1973 · S/N 18502190 N70488Hand Kevin D · Anchorage, AKBuilt 1973 · S/N 18502191 N7048NBonanza Enterprises LLC · Mill Valley, CABuilt 1967 · S/N D-8636 N7049NJ M Williams LLC · Stockton, CAFirst renewal noticeBuilt 1967 · S/N D-8638 N704BAiron2 LLC · Austin, TXBuilt 2001 · S/N E-3372 N704BNWipaire Inc · South Saint Paul, MNBuilt 1982 · S/N 18504380 N704NEArian Air LLC · Cambridge, MABuilt 2004 · S/N 1016

Back to AD 86-13-04 R3