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.

N5966JWydronek Joseph A · Tucson, AZBuilt 1975 · S/N 18263590 N5967BKelley William P · Herron, MIBuilt 1956 · S/N 33967 N5968BLawrence Jon D · Williamsburg, MIBuilt 1957 · S/N 33968 N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969 N596DLCrater Lake Leasing LLC · Las Vegas, NVBuilt 1977 · S/N 18265642 N597KKriedeman Daniel Paul · Port Orange, FLBuilt 1949 · S/N 7403 N5982FCharles James Brown · Littlefield, TXS/N 21058982 N5983BNck Consulting LLC · Scottsdale, AZBuilt 1956 · S/N 33983 N5983ESweet R Kent Trustee · Reno, NVBuilt 1983 · S/N 18268341 N5984Eberle Larry L · Humble, TXBuilt 1971 · S/N 18260841 N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984 N5984JZogleman Enterprises Inc · Viola, KSBuilt 1975 · S/N 18263599 N5985JRuby Crest LLC · Girdwood, AKBuilt 1975 · S/N 18263600 N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986 N5988BLarsen Christopher S · Pleasanton, CAS/N 33988 N598MCTeichroeb Peter · Seminole, TXBuilt 1998 · S/N 18280206 N5995BWilson Robert E III · Urbanna, VABuilt 1956 · S/N 33995 N5995JYachal Benedick · Wilsey, KSBuilt 1975 · S/N 18263604 N5996BStrong Brian S · Southport, NCBuilt 1956 · S/N 33996 N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996 N5996JEvergreen Flying Club Inc · Medina, WABuilt 1975 · S/N 18263605 N5997BSpence Joseph H · Enterprise, ORBuilt 1956 · S/N 33997 N5998BConroy Bruce M · Martinez, CABuilt 1956 · S/N 33998 N5998FMedic Choppers LLC · Springdale, ARS/N 21058998 N5999BBig Bird LLC · Prescott, AZBuilt 1957 · S/N 33999 N599CPCoons Aircraft Services Inc · West Palm Beach, FLBuilt 1968 · S/N 18258960 N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509 N59BMLissow William M · New Port Richey, FLBuilt 1959 · S/N 52120 N59CKSig Properties LLC · Helena, ARFirst renewal noticeBuilt 1972 · S/N 18261416 N59EFTancredi Andrew D · Germantown, TNBuilt 2004 · S/N 18281359 N59KHKrause Wesley A · Big Bear City, CABuilt 1972 · S/N 18261378 N59KMMatthews Casey D · Fort Worth, TXBuilt 1959 · S/N 50503 N59MJSweatt Greg · Cochise, AZBuilt 1970 · S/N 18260369 N59MPPilch Michael Joseph · Sheridan, WYBuilt 1959 · S/N 50624 N59WAAdventist World Aviation Inc · Wilson, NCBuilt 1975 · S/N U20602958 N5DJMyers Bradley J · Madisonville, KYBuilt 1974 · S/N 21060399 N5EA310 LLC · Conover, NCBuilt 1975 · S/N U20602711 N5GSOllman Matthew P · Poplar Grove, ILS/N 33721 N5HRRay Tanner Motors Inc · Phoenix, AZFirst renewal noticeBuilt 1980 · S/N 18267523 N5LSE&K Aero LLC · Friendswood, TXBuilt 1969 · S/N 18259862 N5NHower James A · Horseshoe Bay, TXBuilt 1949 · S/N 7356 N5PCKeck Kevin W Trustee · Meridian, IDBuilt 1977 · S/N 18265656 N5QUnusual Attitudes LLC · Thomas, OKBuilt 1982 · S/N 18268247 N5SCGarrett John R II · Waxhaw, NCS/N 18261939 N5VAVirginia Department Of Aviation · Richmond, VABuilt 1976 · S/N U20603223 N5VEMurphee Koby T · Spirit Lake, IDBuilt 1976 · S/N 18264950 N5ZBBlue Aviation Inc · Venice, FLFirst renewal noticeBuilt 1972 · S/N 18261631 N5ZZLeirer Von O · Los Gatos, CABuilt 1977 · S/N 18265840 N6000LDoherty Douglas E · Nome, AKBuilt 1955 · S/N 31877 N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002

Back to AD 84-10-01 R1