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.

N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263 N2384XHill James P · Eagle Point, ORBuilt 1965 · S/N 18256284 N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172 N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173 N2387CEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 30687 N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587 N2387GPitsch Air Service · Grand Rapids, MIBuilt 1959 · S/N 51687 N2387RLeroux Fernand Dean · Lagrange, GABuilt 1964 · S/N 18255487 N2388CRicottilli Stanley L · Mill Creek, WVBuilt 1953 · S/N 30688 N2388GFlat Top Sheep Co · Carey, IDBuilt 1958 · S/N 51688 N2388XSeiler Richard · Bozeman, MTBuilt 1965 · S/N 18256288 N2389RB2fh Ltd · Allentown, NJBuilt 1964 · S/N 18255489 N238CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283016 N238DSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608238 N238ESSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 52854 N2390SPowerhawk Flyers LLC · Farmington Hills, MIBuilt 1976 · S/N 21061266 N2391BAviation Consultants Inc · Nashville, TNBuilt 1999 · S/N 18280455 N2391FBlue Horizon Consulting LLC · Toccoa, GABuilt 1965 · S/N 21058591 N2391GSeay Bradley Andrew · Vienna, VABuilt 1999 · S/N 18280536 N2392CRoot Eric J · Lakewood, COBuilt 1954 · S/N 30692 N2392FDingo Aviation LLC · Kalispell, MTBuilt 1965 · S/N 21058592 N2392RHarvey Aaron C · Bandon, ORS/N 18255492 N2392XSmm Leasing LLC · Camp Verde, AZBuilt 1965 · S/N 18256292 N2393CKocon Tyler · Puyallup, WABuilt 1954 · S/N 30693 N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593 N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594 N2394SSale Reported · Wild Rose, WISale reportedBuilt 1979 · S/N R18201336 N2394XPierson Daniel · Kalispell, MTS/N 18256294 N23959State Of Wisconsin · Madison, WIBuilt 2006 · S/N 18281748 N2395RSweitzer Derrick L · Stewartstown, PAS/N 18255495 N2395XEdwards Keith D · Olathe, KSBuilt 1965 · S/N 18256295 N2396FFlippin Birds Aviation LLC · Mobile, ALBuilt 1965 · S/N 21058596 N2396GLee James R · Hamilton, TXBuilt 1958 · S/N 51696 N2396KWhitley Pat · Altoona, ALBuilt 2006 · S/N 18281750 N2396RLucky Aviation LLC · Cincinnati, OHBuilt 1964 · S/N 18255496 N2397GHargis William J · Covina, CABuilt 1958 · S/N 51697 N2397RElevate Air LLC · Sandy, UTBuilt 1964 · S/N 18255497 N2397XDow Todd J · Wasilla, AKBuilt 1965 · S/N 18256297 N2398FHorizon Flying LLC · Wilmington, DEBuilt 1965 · S/N 21058598 N2398XPerry Brian J · Stuart, FLBuilt 1965 · S/N 18256298 N2399FJordan Danny L · Medford, ORBuilt 1965 · S/N 21058599 N2399GJohansson Ronny · Wasilla, AKBuilt 1958 · S/N 51699 N239TRosman Patrick R · Creston, WABuilt 1955 · S/N 31775 N239WMPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1953 · S/N 30383 N23CCulver Marc D · Anchorage, AKS/N 18256046 N23CBNb Tweet And Sons · Nome, AKS/N 18503331 N23CFYr-Aircraft Leasing LLC · Bethel, AKBuilt 1974 · S/N 20700276 N23DHOrtiz Guillermo · Puyallup, WABuilt 1975 · S/N 18264053 N23FOurada Mary E Trustee · Tulsa, OKBuilt 1962 · S/N 205-0073 N23FGState Of California Dept Of Fish & Game · Sacramento, CABuilt 1980 · S/N 18504035

Back to AD 84-10-01 R1