Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N9866AKellum Mark J · Belden, MSBuilt 1950 · S/N 7568 N9867XMulligan Kevin S · Port Alexander, AKS/N 185-0067 N9868XBaysinger Harold · Fairbanks, AKBuilt 1961 · S/N 185-0068 N9869CSouthern Star Holdings LLC · Safety Harbor, FLBuilt 1978 · S/N R18200476 N9869ESystems Management Consulting Group LLC · St Michaels, MDBuilt 1975 · S/N 18263930 N9869HFoxtrot Alliance LLC · Southlake, TXBuilt 1981 · S/N 18268082 N9869MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1981 · S/N 20700744 N986DKNbr Aviation · Bristow, VABuilt 2010 · S/N 18282230 N986MTOtv Leasing · Bristow, VABuilt 2010 · S/N 18282217 N9870ETts Calif LLC · Red Bluff, CABuilt 1985 · S/N 18268457 N9870YDejong Arie H · Maricopa, AZFirst renewal noticeBuilt 1981 · S/N 21064621 N98715Moses Ezra R · Windham, NHBuilt 1998 · S/N 18280356 N9871ARegistered aircraftBuilt 1950 · S/N 7607 N9871EBonac Air Flying Club · Montauk, NYBuilt 1975 · S/N 18263932 N9872EMckoane Christina Elizabeth · Vail, COBuilt 1985 · S/N 18268458 N9873EFiedler Andrew T · Houston, TXBuilt 1985 · S/N 18268459 N9873XMckenna Brothers Aircraft LLC · Anchorage, AKBuilt 1961 · S/N 185-0073 N9875XCropper Ryan D · Anchorage, AKBuilt 1961 · S/N 185-0075 N9876ERegistered aircraftBuilt 1975 · S/N 18263937 N9876MErkie Norman R · Denison, TXBuilt 1976 · S/N 18264774 N9876ZGv Air Inc · Medford, ORBuilt 1983 · S/N U20606721 N9877EKa Flying LLC · Dalhart, TXBuilt 1985 · S/N 18268460 N9877HCowden William H Jr · Kerrville, TXBuilt 1981 · S/N 18268087 N9877VBellinger Ag Defense LLC · Manhattan, KSBuilt 1966 · S/N 188-0127 N9878EKd Flyers Inc · Lewes, DEBuilt 1975 · S/N 18263939 N9878HHatfield Derik · Mesa, AZBuilt 1978 · S/N 21062885 N9878MA&J Airsales Inc · San Antonio, TXBuilt 1977 · S/N 21062084 N9879ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7581 N9879EMy Way Aviation LLC · Weston, FLBuilt 1985 · S/N 18268461 N9879FClift Murray · Chewelah, WAS/N 18280057 N9879MJersey Cowboy Venture LLC · Casper, WYBuilt 1976 · S/N 18264777 N9879XRegistered aircraftBuilt 1961 · S/N 1850079 N987AFAero Fliers Inc · Akron, OHFirst renewal noticeBuilt 1978 · S/N 18266588 N987CZQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 18266561 N987FMMobile County Health Department · Mobile, ALBuilt 1978 · S/N 18266706 N987MZanze David · Cedar City, UTBuilt 1975 · S/N 21061093 N987PLColestine Holdings LLC · Ashland, ORBuilt 1985 · S/N 21064960 N987RPPegasus Flight LLC · Bluffton, SCS/N 18264863 N9880EClint Bowyer Racing Inc · Clemmons, NCBuilt 1975 · S/N 18263941 N9881ESchmitt Rudy · Bulverde, TXS/N 18263942 N9881MDietz David Brian · East Canton, OHBuilt 1976 · S/N 18264779 N9882ASchmidt Aaron B · Auburn, ALBuilt 1950 · S/N 7584 N9882EWilson Randall R · Roseville, CABuilt 1975 · S/N 18263943 N9883ANelson Larry D · Springfield, MOBuilt 1950 · S/N 7585 N9883HRegistration Pending · Franklin, TXRegistration pendingBuilt 1981 · S/N 18268090 N9883MJacques Tommy E Jr · Montgomery, ALBuilt 1976 · S/N 18264781 N98840Aviator Air Flight School LLC · Grand Prairie, TXBuilt 1998 · S/N 18280358 N98853Registered aircraftBuilt 1998 · S/N 18280316 N9885APmc Aviation LLC · Payson, AZBuilt 1950 · S/N 7638 N9885FSky View LLC · Madison, MSBuilt 1998 · S/N 18280148

Back to AD 84-10-01 R1