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.

N5411BBailey Carl D · Huntington, WVBuilt 1956 · S/N 33411 N5411XUsda Aphis Ppq · Edinburg, TXBuilt 1980 · S/N U20605727 N5412NCat Claw Aviation LLC · San Antonio, TXBuilt 1980 · S/N 18267763 N5412SBarrett E James · Queensbury, NYBuilt 1980 · S/N R18201567 N5416UU S Department Of Agriculture · College Station, TXBuilt 1984 · S/N 21064890 N5416YKer Holdings LLC · Henderson, NVBuilt 1980 · S/N 21064199 N5417BKnutson Wayne R · Thompson, NDBuilt 1956 · S/N 33417 N5417YFeldner Mark A · Schererville, INBuilt 1980 · S/N 21064200 N5419NTwallace LLC · Griffin, GABuilt 1980 · S/N 18267702 N541JBHuffman Aviation LLC · Burleson, TXBuilt 1981 · S/N R18201752 N541JKKubik James T · Beach City, TXBuilt 1954 · S/N 31166 N5420NAdelman Hiram · Bass Harbor, MEBuilt 1980 · S/N 18267703 N5422Fitzstephens Erik · North Pole, AKS/N 180-51317 N5422BR & R Aviation LLC · Arnaudville, LABuilt 1956 · S/N 33422 N5423BBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1956 · S/N 33423 N5424AFudurich David E · Goleta, CABuilt 1979 · S/N 21063428 N5424UWsol Michael P DBA · Huntington Beach, CABuilt 1979 · S/N U20605287 N5425AValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N 21063429 N5425BEslinger Beau T · Tucson, AZBuilt 1956 · S/N 33425 N5425SBunn James W · New Port Richey, FLBuilt 1980 · S/N R18201570 N5426CVirginia Air Inc · Roanoke, VABuilt 1979 · S/N 21063749 N5427BYeary Clifton K · Quitaque, TXBuilt 1956 · S/N 33427 N5427XRegistered aircraftBuilt 1980 · S/N U20605743 N5428UCordova Air Service Inc · Cordova, AKBuilt 1979 · S/N U20605290 N542CGulf States Financial Services · Lafayette, LAS/N 21063919 N542EBSvoboda Erik S · Mentor, OHBuilt 1981 · S/N 21064351 N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691 N542SWHardy Tracy G · Tucson, AZBuilt 1978 · S/N 18266661 N5430AAdams Hay Farms LLC · Cedar City, UTBuilt 1979 · S/N 21063433 N5431BRi Skydiving Aircraft LLC · Middletown, RIBuilt 1956 · S/N 33431 N5432BDixon Charles W · Brookhaven, MSBuilt 1956 · S/N 33432 N5432VMj Aerial LLC · Wasilla, AKS/N 18257941 N5433BBlue Moon Aviation LLC · Grangeville, IDBuilt 1956 · S/N 33433 N5433XMk Air LLC · Lewistown, MTBuilt 1980 · S/N U20605749 N5434ASteele Group Insurance Agency Inc · Eugene, ORBuilt 1979 · S/N 21063436 N5434VInhouse Graphics Inc · Brookshire, TXBuilt 1975 · S/N 21060947 N5435BMacomber Gregory S · Kalamazoo, MIBuilt 1956 · S/N 33435 N5436AJls Investments Inc · Lafayette, LAS/N 21063437 N5436UNewsom William Joel III · Roswell, GAS/N 21064892 N5438BMoore Ryan T · Nampa, IDS/N 33438 N5438ECsp Aviation LLC · Stuart, FLBuilt 1983 · S/N 18268319 N5439CLopez Hugo E · Mcallen, TXFirst renewal noticeBuilt 1979 · S/N 21063755 N543EMPacific Air Flight School LLC · Long Beach, CABuilt 1978 · S/N 21063054 N543JRRahns Inc · Enterprise, ORBuilt 1964 · S/N 205-0480 N543MCJoe Morten & Son Inc · S Sioux City, NEBuilt 1999 · S/N 18280548 N5440BCline Thomas E · Santee, CABuilt 1956 · S/N 33440 N5440NKenosha Airmens Flying Club Inc · Twin Lakes, WIBuilt 1980 · S/N 18267716 N5441BFour One Bravo LLC · Piedmont, SCBuilt 1956 · S/N 33441 N5442NDeruwe Karl J · Othello, WABuilt 1980 · S/N 18267718 N5445BWilds Terrance L · Grand Rapids, MIBuilt 1956 · S/N 33445

Back to AD 84-10-01 R1