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.

N6927RSavord George Kevin · Boulder City, NVBuilt 1967 · S/N T210-0327 N6929Monsen Ronald · Naperville, ILBuilt 1969 · S/N 18259853 N6929JMhz5620 LLC · Fitchburg, WIBuilt 1998 · S/N 18280158 N6929RShelfer Douglas · Arlington, TXBuilt 1967 · S/N T210-0329 N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331 N6932RBoxwell Avionics · Green Cove Springs, FLS/N T210-0332 N6936MNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1975 · S/N 18263895 N6936RKingrey William S III · Richmond, TXBuilt 1967 · S/N T210-0336 N6939NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 21063161 N6939RGalloway Kyle J · Bradshaw, NEBuilt 1967 · S/N T210-0339 N693DADirect Action Aviation LLC · Reno, NVS/N 18259845 N6942VWaters Tracy J · Pittsboro, NCBuilt 1975 · S/N 18052566 N6944RSilcox Cleven L · Sapulpa, OKBuilt 1968 · S/N T210-0344 N6945RDonham William David · Odessa, TXS/N T210-0345 N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346 N6949RElyan Aviation Inc · Palm Springs, CABuilt 1968 · S/N T210-0349 N694MDBice Eric L · Renton, WABuilt 1959 · S/N 50694 N694MMBrown Ryan W · Nampa, IDBuilt 1969 · S/N 18259874 N694QPhillips Todd · New Albany, MSBuilt 1963 · S/N 18254585 N694SAMile High Ventures Inc · Palm Harbor, FLBuilt 2000 · S/N 18280803 N694SMSurveying And Mapping LLC · Austin, TXBuilt 2004 · S/N 20608223 N694TCBruton Aerial Spraying Inc · Garden City, TXS/N 20608069 N6951MDavid Paul T · Santa Barbara, CABuilt 1975 · S/N 18263896 N6953MN6953m Kemt Aircraft LLC · Monrovia, CABuilt 1975 · S/N 18263898 N6955VNeu Timothy F · Orlando, FLBuilt 1965 · S/N 18256630 N695XCloud 9 Aviation LLC · Bismarck, NDBuilt 1980 · S/N R18201592 N6962MAbramson Jerrold B Trustee · Simi Valley, CABuilt 1975 · S/N 18263901 N6963MHathaway Virgil F · Spokane, WABuilt 1975 · S/N 18263902 N6967BChalk 2 Inc · Apple Valley, CABuilt 1978 · S/N 21062857 N6967NSand Creek Oil & Gas Inc · Edmond, OKBuilt 1979 · S/N 21063177 N6968ZMeili Charles E · Kingwood, TXBuilt 1965 · S/N 185-0968 N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150 N696EAHubbard Broadcasting Inc · Saint Paul, MNBuilt 2005 · S/N 18281722 N696MMShimoda Aviation LLC · Hawthorne, FLBuilt 1968 · S/N 18259202 N696PRDeliberty Michael J · Townsend, DEBuilt 1964 · S/N 205-0546 N696SAThree Green Aviators LLC · Midland, TXBuilt 2000 · S/N 18280845 N6970NSeitz Thomas J · Mission, KSFirst renewal noticeBuilt 1979 · S/N 21063179 N6972NEnns Robert B · Cayucos, CABuilt 1979 · S/N 21063181 N6976NCenturion Capital Partners LLC · Blue Ash, OHBuilt 1979 · S/N 21063185 N6977BCollins Kevin T · Roseville, CABuilt 1978 · S/N 21062862 N6979BCenturion Bravo LLC · Houston, TXBuilt 1978 · S/N 21062863 N6979NArango Jorge · Mcallen, TXBuilt 1979 · S/N 21063188 N6980MPetumenos Timothy James · Anchorage, AKBuilt 1977 · S/N 21062005 N6989MRp Wellons Aircraft LLC · Dunn, NCBuilt 1975 · S/N 18263910 N698MCRegistered aircraftBuilt 1998 · S/N 18280336 N6990YV Speed Aviation LLC · Reno, NVBuilt 1964 · S/N 21058490 N6993NSp Aircraft LLC · Moscow, IDBuilt 1979 · S/N 21063202 N6994MParish John L Sr · Tullahoma, TNBuilt 1978 · S/N U20604513 N69995Hillis Larry Gregory · Pickens, ARBuilt 1965 · S/N 18256289 N6999MAbonil Ty · Philadelphia, PABuilt 1964 · S/N 18255790

Back to AD 84-10-01 R1