Registered aircraft · 20,484

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.

N188MESenior Mi LLC · Batavia, ILBuilt 2000 · S/N 20608108 N1890ZAlaniz Jose M · Yreka, CABuilt 1962 · S/N 205-0090 N1891MStarkman Timothy S · Monterey, CABuilt 1975 · S/N 18264470 N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792 N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992 N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793 N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994 N1894ZEverly Peter · Fort Smith, ARBuilt 1962 · S/N 205-0094 N1896BSmart John B III · Southlake, TXBuilt 2005 · S/N 18281731 N1896XSmr Holdings LLC · Martinsburg, WVBuilt 1964 · S/N 18255996 N1898ZSmart Robbie A · Wasilla, AKBuilt 1962 · S/N 205-0098 N1899MLoki Adventures LLC · Norwood, COBuilt 1975 · S/N 18264472 N1899ZLarlee Coleman R · Millbrook, ALBuilt 1962 · S/N 2050099 N189CFRascher Lawrence · Pacific, MOS/N 18255465 N189CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281989 N189JAPapillon Airways Inc · Kirkland, WABuilt 1969 · S/N 18259569 N189PSchwartz Stephen R · Goldthwaite, TXBuilt 1950 · S/N 7488 N189SElfdog Aviation LLC · New Franken, WIBuilt 1960 · S/N 52778 N189WHBonafide Investments LLC · Dover, DEBuilt 1969 · S/N 18052059 N18ADEzs Flyers LLC · Bonduel, WIBuilt 1972 · S/N 18261116 N18CDDorman Richard E · Mesa, WABuilt 1964 · S/N 18051402 N18CLAkro Attitudes Inc · Boynton Beach, FLS/N 52838 N18DMRachal Randolph B · Taft, TXBuilt 1969 · S/N 18259374 N18HBBuermann Henry · Brookfield, VTS/N 30912 N18HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281071 N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903 N18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNBuilt 1978 · S/N R18200178 N18PBStogner Terry W · Lamesa, TXBuilt 1967 · S/N 18258216 N18PMNoel Michael Patrick · Poplar Grove, ILS/N 18280300 N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192 N18SBTroy Motz Construction Inc · Lincolnton, NCBuilt 1978 · S/N 18266338 N18TBCarlson Herb Trustee · Dana Point, CABuilt 1981 · S/N 18267978 N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360 N18TLCarey Nicolas J · Rosamond, CAS/N 18259225 N18WLMiller Christopher M · Centreville, VABuilt 1981 · S/N 18053178 N18ZPPierce Lestley R · Henderson, NVS/N 18263562 N1900XAtkinson Ron D · Myrtle Creek, ORBuilt 1965 · S/N 18256000 N1901XBuehler Jon R Trustee · Scott City, KSBuilt 1965 · S/N 18256001 N19022Delta Lima Foxtrot LLC · Kalispell, MTBuilt 1980 · S/N 18053176 N1902XKelly Jerome · Babbitt, MNBuilt 1965 · S/N 18256002 N1903XAivcon Inc · Charlevoix, MIBuilt 1965 · S/N 18256003 N1904FRoberts Walter A · Emery, SDBuilt 1966 · S/N 18257699 N1904UAircraft Partner Holdings Inc Trustee · BerlinBuilt 1950 · S/N 7592 N1905ULeichtfuss Brad · Lake Havasu City, AZBuilt 1973 · S/N U20602275 N1906FP206-1 LLC · Carrollton, GABuilt 1964 · S/N P206-0001 N1906XLawless Mark · Des Moines, IABuilt 1965 · S/N 18256006 N1908MAirtrader LLC · Hornersville, MOBuilt 1975 · S/N 18264473 N1909XBowie Dana M · England, ARBuilt 1965 · S/N 18256009 N190DFFuller Darel C · Moses Lake, WABuilt 1952 · S/N 7786 N190DMMcintyre Donald F · Fort Gratiot, MIBuilt 1978 · S/N 18266049

Back to AD 84-10-01 R1