Registered aircraft · 20,485

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.

N1781CHenkelmann David H · Janesville, WIBuilt 1953 · S/N 30481 N1781RDale Mar Enterprises Inc · Granton, WIBuilt 1978 · S/N R18200557 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N1783MRyan Jason P · San Francisco, CABuilt 1975 · S/N 18264443 N1784MWhitledge Aviation LLC · Princeton, INBuilt 1975 · S/N 18264444 N1784RCunning Aviation LLC · La Mesa, CABuilt 1978 · S/N R18200558 N1785CBorns Frederick G · Chandler, AZBuilt 1953 · S/N 30485 N1786RWhalen Dann Trustee · San Diego, CABuilt 1978 · S/N R18200559 N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806 N1787CMorris Charles W · Wasilla, AKBuilt 1953 · S/N 30487 N1789CBuxton Tracy S · Enterprise, UTBuilt 1953 · S/N 30489 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445 N178ZLUsda Forest Service Fepp · Columbia, SCBuilt 1963 · S/N 18254850 N1794CAcp Aviation LLC · Oakdale, LABuilt 1953 · S/N 30494 N1794MSkyriders Flying Club Inc · Aurora, COBuilt 1975 · S/N 18264447 N1794XGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 21060814 N1795CSchellhaas Bennett · Galloway, OHBuilt 1953 · S/N 30495 N1797CKelley Larry D · Portland, ORBuilt 1953 · S/N 30497 N1797MCp & R Transport LLC · Grace, IDBuilt 1975 · S/N 18264450 N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N1798MWalker Steven C · Lake Havasu City, AZBuilt 1975 · S/N 18264451 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N179CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282339 N179JSMcdonald Timothy Steven · Slaton, TXBuilt 2004 · S/N 18281481 N179WSEbken Gary R · Loxahatchee, FLBuilt 1959 · S/N 51698 N179WZCatterton Jane S · Signal Mountain, TNBuilt 1981 · S/N 18268036 N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674 N17BHFoster Brian J · Mancelona, MIBuilt 1972 · S/N 18261384 N17CJ16d Aviation LLC · Vashon, WABuilt 1968 · S/N U206-1199 N17FCUsda Forest Service Fepp · Columbia, SCBuilt 1970 · S/N 18260269 N17GNGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700693 N17HPState Of Ohio Dept Of Public Safety · Columbus, OHBuilt 2004 · S/N 18281436 N17HSRed Oak Centurion LLC · Red Oak, IABuilt 1967 · S/N 21058844 N17JYYorkavitz James B · Valley City, OHBuilt 1969 · S/N 21059154 N17MMBekanich Jason · Camden, NCBuilt 1967 · S/N 18258323 N17NFBravo Hotel LLC · Lewes, DES/N P206-0369 N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499 N17YRNagle Jeffrey · Fremont, INS/N 18282456 N180Moore James M · Grass Valley, CABuilt 1978 · S/N 18052946 N1800FReid Brian M · Boise, IDBuilt 1965 · S/N 21058700 N1800QNiswander Richard A · Upton, KYBuilt 1961 · S/N 18253196 N1800RSugrue Aviation Inc · Silver City, SDBuilt 1978 · S/N R18200563 N1800XValentine Edward Lawson · Dallas, TXFirst renewal noticeBuilt 1964 · S/N 18255900 N1801XClark Curtis S · New Carlisle, OHBuilt 1965 · S/N 18255901 N1801ZGould Robert R Jr · Sterling, VABuilt 1962 · S/N 205-0001 N1802Long Randy B · Coleman, TXBuilt 1957 · S/N 34085 N1802FSantiago Ferdinand · Calhoun, GABuilt 1965 · S/N 21058702 N1802ZSparks Timothy J · Jackson, MIBuilt 1962 · S/N 205-0002 N1803MWhitfield Edward · Mcpherson, KSBuilt 1975 · S/N 18264454

Back to AD 84-10-01 R1