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.

N2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARBuilt 1965 · S/N 210-58516 N2317GOrion Aviation LLC · Edmond, OKS/N 21061485 N2317XSproul Wendell C · Hermon, MEBuilt 1965 · S/N 18256217 N23182Costello Lisa · The Woodlands, TXBuilt 2023 · S/N 18283218 N2318CWebster Robert C · East Jordan, MIBuilt 1953 · S/N 30618 N2318FBe Dozer LLC · Guy, ARS/N 21058518 N2318GRedmond John R · Reno, NVS/N 51618 N2318RJigamian Geoffrey T · Temecula, CABuilt 1964 · S/N 18255418 N2319FDelaney Patrick J · Marion, TXBuilt 1964 · S/N 21058519 N2319GSkydive Co · Fairburn, GABuilt 1958 · S/N 51619 N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245 N231PABone Jason T · Bulverde, TXBuilt 2000 · S/N 18280848 N231SPIowa State Patrol · Des Moines, IABuilt 2011 · S/N 18282299 N2320GStocker Earnest E · Krum, TXBuilt 1959 · S/N 51620 N2321FMilson Charles · Sanford, NCBuilt 1964 · S/N 21058521 N2322CTwin Otter Internatinal Ltd · Las Vegas, NVBuilt 1953 · S/N 30622 N2322GBaker Harry K · Phoenix, AZBuilt 1958 · S/N 51622 N2322RSink Lendon V · Lexington, NCBuilt 1964 · S/N 18255422 N2323COrvin Sanden Inc · Wyndmere, NDBuilt 1953 · S/N 30623 N2323FMattern Rodney · Napoleon, NDS/N 21058523 N2323GLeone Daniel M · Pueblo, COBuilt 1958 · S/N 51623 N2323ZCalahan Spencer H · Baton Rouge, LABuilt 2023 · S/N 18283245 N2324FLong Rendell L · Woodbridge, VABuilt 1964 · S/N 21058524 N2324RKincheloe Ralph H · Jerome, IDBuilt 1964 · S/N 18255424 N2324XSchutjet Dennis · Clear Lake, IABuilt 1965 · S/N 18256224 N2325FStephen N Ruark Farm Services Inc · Pantego, NCBuilt 1964 · S/N 21058525 N2325RLucky Catch LLC · Canton, MSS/N 18255425 N2326BRandigo LLC · Wilmington, DEBuilt 1978 · S/N U20604470 N2326RSinger Don · Oxnard, CABuilt 1964 · S/N 18255426 N2326XFerris Elden L · Vancouver, WABuilt 1965 · S/N 18256226 N2327FWilliams Stephen Mark · Fort Walton Beach, FLBuilt 1964 · S/N 21058527 N2329GRegistration Pending · Eagle River, AKRegistration pendingBuilt 1959 · S/N 51629 N2329RRivers Andrew · Midland Park, NJS/N 18255429 N232AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281180 N232ESBayside Beach Resort LLC · Tavernier, FLFirst renewal noticeBuilt 2005 · S/N 18281540 N232MEDunbar Joseph · Greensboro, NCBuilt 2000 · S/N 18280749 N232MTAir Force Life Cycle Management Center · Lexington, MABuilt 1981 · S/N U20606200 N232SBEagle Crest 2sb LLC · Milton, DEBuilt 1998 · S/N 18280211 N232ZVance Jordan Enterprises Inc · Wilmington, DEBuilt 2005 · S/N 18281627 N2330GEmshwiller Mark E · Camp Verde, AZBuilt 1958 · S/N 51630 N2330JWilliamsburg Air Service Inc · Kingstree, SCBuilt 1979 · S/N T18803455T N2330XKeller Ronald B · Bosque Farms, NMBuilt 1965 · S/N 18256230 N2331FReeves Thomas W · Issaquah, WABuilt 1964 · S/N 21058531 N2331GSouth Bay Aviation Inc · Torrance, CAS/N 51631 N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431 N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632 N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152 N2333GRegistration Pending · Belen, NMRegistration pendingS/N 51633 N2333KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N U20603676 N2333XHjr Aviation LLC · Reno, NVBuilt 1965 · S/N 18256233

Back to AD 84-10-01 R1