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.

N6569ABallard Scott K · Collierville, TNBuilt 1956 · S/N 32466 N6569MBrown George P III · Houston, TXBuilt 1975 · S/N 18263760 N656CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281656 N656DGD Gordon Aviation Inc · La Jolla, CABuilt 1977 · S/N R18200042 N656EMAxis Electric Inc · Albany, ORBuilt 1975 · S/N 18263945 N656FCFlorida Department Of Agriculture & Consumer Svcs · Tallahassee, FLBuilt 2017 · S/N 18283008 N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111 N6570AKunz Ethan · Ashland, ORBuilt 1956 · S/N 32467 N6570MJones Brandon · Steele, MOBuilt 1975 · S/N 18263761 N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444 N6575AWhitmore Alex · Terlingua, TXBuilt 1956 · S/N 32472 N6576NFaaz Aircrafts LLC · Irving, TXBuilt 1981 · S/N 18267839 N6576XG23 Holdings LLC · Hollywood, FLBuilt 1960 · S/N 21057576 N6577ANafus Gifford William · Palmer, AKBuilt 1956 · S/N 32474 N6577DScootair LLC · Alburgh, VTS/N 7847 N657CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281657 N657TPZma LLC · North Little Rock, ARBuilt 2010 · S/N 18282253 N6580AHelleloid Kristen L · Intl Falls, MNBuilt 1956 · S/N 32477 N6582AN6582a Leasing Service LLC · Wasilla, AKBuilt 1956 · S/N 32479 N6582MHayward W Blair · Brooks, GAS/N 18263764 N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958 N6583MParnell Kevin T · Buhl, IDBuilt 1975 · S/N 18263765 N6584AWildman Air LLC · Mckinney, TXBuilt 1956 · S/N 32481 N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112 N65853Morando Donald W · Myrtle Beach, SCBuilt 2004 · S/N 18281490 N65860Edb Air Inc · Wilsonville, ORBuilt 2004 · S/N 18281491 N65862Top Flight Aviation Inc · Corona, CABuilt 2004 · S/N 18281493 N6587ADuncan William K · Collierville, TNBuilt 1956 · S/N 32484 N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962 N6589MHaller Eugene Z · East Hampton, NYBuilt 1977 · S/N 21061979 N658BWKatmai 658bw LLC · Sun Valley, IDBuilt 1980 · S/N 18267669 N658CPArizona Air Salvage · Phoenix, AZBuilt 2005 · S/N 18281658 N658JMBlackbird Aero LLC · Boca Raton, FLS/N 18268228 N658PWWheels Up Aviation LLC · Cochran, GABuilt 2008 · S/N 18282098 N65903N65903 LLC · Union Gap, WABuilt 2004 · S/N 18281501 N65904Electra Aviation LLC · Wilmington, DEBuilt 2004 · S/N 18281502 N6590MOpm Holdings LLC · Wilmington, DEFirst renewal noticeBuilt 1975 · S/N 18263768 N6591NRickey James R · Hanford, CAFirst renewal noticeBuilt 1978 · S/N 21063114 N65937Berendschot Leonardus · Huntsville, TXBuilt 2004 · S/N 18281492 N6593XWondra J Paul · Newbury Park, CAS/N 21057593 N6594EAirlake Aero Inc · Lakeville, MNBuilt 1984 · S/N 18268375 N6594MRayburn William E · Oak Harbor, OHBuilt 1975 · S/N 18263770 N65957Skybourne LLC · Stuart, VABuilt 2004 · S/N 18281484 N6596MEjs Enterprises Inc · Three Forks, MTBuilt 1975 · S/N 18263771 N65988Arkansas Industrial Manufacturing LLC · Wilmington, DEBuilt 2005 · S/N 18281513 N6598ESmith Jeff · Papillion, NEBuilt 1984 · S/N 18268376 N6598XVolk Kenneth L · Waskom, TXS/N 21057598 N65991Crysler Douglas Michael · Rockford, MIBuilt 2005 · S/N 18281514 N65992Holseberg Aviation LLC · Ridgeville, SCS/N 18052902 N65995Phoenix Flyers Inc · Mesa, AZBuilt 2005 · S/N 18281515

Back to AD 84-10-01 R1