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.

N699CBBig Skylands Aviation LLC · Succasunna, NJBuilt 2001 · S/N 18281033 N699CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283103 N699EEMathes Jay B · Ridgecrest, CABuilt 1976 · S/N 21061184 N699JGJaymar Aviation LLC · Flagstaff, AZBuilt 1973 · S/N 18261883 N699JMSky West Aviation Inc Trustee · Albuquerque, NMS/N 18264142 N699WWWallis Warren · Barstow, CABuilt 1969 · S/N 21059161 N699XMBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 182-67158 N69ACKendel Stephen George · Colbert, WABuilt 1969 · S/N 18260134 N69CHTexarkana Flying Club Inc · Texarkana, TXBuilt 1975 · S/N 18263618 N69DREsi Aviation LLC · Lakewood, COBuilt 1973 · S/N 18261860 N69ELLewis Ethel M · Castro Valley, CABuilt 1962 · S/N 18254060 N69HZU206 Ice LLC · Pompano Beach, FLS/N U206-1253 N69LEEle Motorsports LLC · Dover, DES/N 21062897 N69PRAero Inventory LLC · Monroe, GAS/N T210-0321 N69RLLivingston Robin L · Vail, AZBuilt 1960 · S/N 57287 N69TRZg Ltd · Green Cove Springs, FLBuilt 1977 · S/N 18265513 N69UTAux N69ut LLC · Portland, TXBuilt 1968 · S/N 18259464 N69WKirby Mitchell E · Gualala, CABuilt 1968 · S/N 18259436 N69WAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1982 · S/N 21064707 N69WESlate Kevin Dwayne · Bell Buckle, TNBuilt 1972 · S/N 182-61092 N6AWH & H Hanger LLC · El Campo, TXBuilt 1974 · S/N 18262961 N6BKAerovana LLC · Caldwell, IDBuilt 1976 · S/N 18052691 N6CRJ R Systems LLC · Kenedy, TXBuilt 1977 · S/N 18266190 N6CWRegistered aircraftBuilt 1973 · S/N 18262125 N6DEE & R Properties Of Florence LLC · Ridgeway, SCBuilt 1978 · S/N 21062802 N6DNLowery William D · Geneva, FLBuilt 1963 · S/N 18255161 N6DRHiggins Robert DBA · Gill, MABuilt 1979 · S/N 18266779 N6HGBagwell Harold G · Garner, NCBuilt 1978 · S/N 21062624 N6HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281070 N6HQNazir Donna La Cruz · Boca Raton, FLBuilt 1966 · S/N U206-0581 N6HRKornegay Stephanie L · Charlotte, NCBuilt 1974 · S/N 18263470 N6KKUey Aviation Group LLC · Newtown, CTBuilt 1979 · S/N 18267153 N6LTDierks Herman D Jr · Round Rock, TXBuilt 1970 · S/N 18052111 N6MAShewmaker Air LLC · Bentonville, ARBuilt 1979 · S/N 18267389 N6MDCessna 6md LLC · Englewood, FLBuilt 1963 · S/N 2050315 N6MFMission Aviation Fellowship · Nampa, IDS/N U20605926 N6NXGold James M · Kerrville, TXBuilt 1961 · S/N 18253173 N6PDNewcomb Clint · Benton, ARS/N 21061930 N6QTM And K Industries LLC · Anchorage, AKBuilt 1964 · S/N 18255232 N6SFWeatherbe Mark B · Lincoln, MEBuilt 1974 · S/N 18052498 N6TKPritchard James A III · Maysville, GABuilt 1981 · S/N 180-53186 N6TPRiver Birch Landings LLC · Lewes, DES/N 18263148 N6URAvidyne Corp · Melbourne, FLBuilt 1978 · S/N 18265967 N6WHWoldow Fredric A · Morton, ILBuilt 1974 · S/N 18052492 N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553 N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907 N7003KSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 18259923 N700MTJoey O'S LLC · Darlington, PAS/N R18200996 N700PDAero Survey LLC · Lake Havasu City, AZBuilt 1979 · S/N 18266974 N700RBM & J Flight LLC · Cheboygan, MIBuilt 1973 · S/N 182-62421

Back to AD 84-10-01 R1