Registered aircraft · 20,483

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.

N2493QTarrant Enterprises Inc · Eagle, COBuilt 1966 · S/N 18257693 N2493XKoenig William T · Sauk Centre, MNBuilt 1965 · S/N 18256393 N2494EDuran Louis · Chino, CABuilt 1982 · S/N 18268207 N2494QMcculloch Kyle · Bixby, OKBuilt 1966 · S/N 18257694 N2495FKalbfleisch George R · Dry Ridge, KYBuilt 1966 · S/N 18051697 N2495GHayton James B · Sedro Woolley, WABuilt 1959 · S/N 51795 N2495RSale Reported · Saint Augustine, FLSale reported, canceledBuilt 1964 · S/N 18255595 N2496FKrissman Ryan · Gallup, NMS/N 18051695 N2497GChapman William F · Coeur D Alene, IDBuilt 1959 · S/N 51797 N2497XVoeltzel Rick K · Rio Rico, AZBuilt 1965 · S/N 18256397 N2498FTaylor Andrew A · Ketchikan, AKBuilt 1966 · S/N 18051700 N2498GKc Aircraft LLC · Missoula, MTBuilt 1959 · S/N 51798 N2498RJohnson Christopher A · Pampa, TXBuilt 1964 · S/N 18255598 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N2498XVotava Paul A · Mcintosh, MNBuilt 1965 · S/N 18256398 N249BKWaggoner Carter · Calera, ALBuilt 2021 · S/N 18283148 N249MDMorrison William F · Athol, IDBuilt 1965 · S/N 18051501 N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 21060990 N249WARace Mark · Tyler, TXBuilt 1998 · S/N 182-80103 N24BPMiller Dwayne C · Comanche, TXBuilt 1956 · S/N 32939 N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793 N24CYAllman Darrell W Jr · Edmond, OKBuilt 2022 · S/N 18283165 N24FWatkins Brian · Los Alamos, NMS/N 18266495 N24GCGreene County Sports Parachute · Loretto, KYBuilt 1954 · S/N 31163 N24HPYolo County/Yolo County Sheriffs Office · Woodland, CABuilt 1975 · S/N 18263568 N24HSSandoval Ernest D · Cave Creek, AZBuilt 1978 · S/N 21062755 N24JCEllis Robert W · Gilbert, AZBuilt 1966 · S/N 18257607 N24KWright Douglas J · Greenwood, INBuilt 1960 · S/N 57265 N24NHBeyer Roger · Paw Paw, MIBuilt 1981 · S/N 21064545 N24REMelendez Jesus · North Miami, FLBuilt 1964 · S/N 18255274 N24RHBurns Texas Enterprises Inc · Houston, TXBuilt 1971 · S/N 18260817 N24SCGriffin Samuel C · Doniphan, MOBuilt 1977 · S/N U20603868 N24VEDuke William Thomas · West Point, MSBuilt 1974 · S/N 18262869 N24VVWheels Up LLC · Land O Lakes, WIBuilt 1979 · S/N 18267131 N24WWPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060884 N2500RN2500r LLC · Florence, SCBuilt 1967 · S/N 18258200 N2501QEcological Flight Services LLC · Stuart, FLBuilt 1966 · S/N 18257701 N2501SGonzales Gerald · Dallas, TXS/N 21061307 N2501XRoth Douglas K · Anchorage, AKBuilt 1958 · S/N 51113 N2502RLovell John W · Sherborn, MABuilt 1967 · S/N 18258202 N2503RNicoliei Paul · Ione, CAS/N 18258203 N2504RJht Aviation LLC · Longview, TXBuilt 1967 · S/N 18258204 N2504XInspire Technologies Inc · Caldwell, IDBuilt 1964 · S/N P206-0004 N2505XGaviaire Aviation LLC · El Reno, OKBuilt 1965 · S/N P206-0005 N2506QJohnson Jason D · Doniphan, MOBuilt 1966 · S/N 18257706 N2506SByers Roger G · Lake Elmo, MNS/N 21061309 N2506XBaumberger Gene C · Greenville, ILBuilt 1965 · S/N P206-0006 N2507GBanks Gary M Jr Trustee · Scituate, MABuilt 1959 · S/N 51807 N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469T N2507RKandle Sherry A · Boise, IDBuilt 1967 · S/N 18258207

Back to AD 84-10-01 R1