Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N2392QTwin Eagle Flying Club Inc · Pikeville, KYBuilt 1977 · S/N 28-7790396 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 N2393DSoares Manuel J · Wasilla, AKBuilt 1952 · S/N 20545 N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593 N2393TShool Board Of Marion County Florida · Ocala, FLBuilt 1971 · S/N 28-7225066 N2394DRegistration Pending · Fort Ripley, MNRegistration pendingBuilt 1952 · S/N 20546 N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594 N2394MOld Buzzard Ltd · Columbus, OHBuilt 1977 · S/N 28R-7837085 N2394SSale Reported · Wild Rose, WISale reportedBuilt 1979 · S/N R18201336 N2394XPierson Daniel · Kalispell, MTS/N 18256294 N2395RSweitzer Derrick L · Stewartstown, PAS/N 18255495 N2395TSingh Harsimran · Las Vegas, NVBuilt 1971 · S/N 28-7205049 N2395UBucher Sheldon L · Divide, COBuilt 1962 · S/N 17249995 N2395VConfluence Systems Consulting Inc · San Jose, CAS/N 28-8590069 N2395XEdwards Keith D · Olathe, KSBuilt 1965 · S/N 18256295 N2396DClark Patrick L · Kenai, AKS/N 20548 N2396FFlippin Birds Aviation LLC · Mobile, ALBuilt 1965 · S/N 21058596 N2396GLee James R · Hamilton, TXBuilt 1958 · S/N 51696 N2396RLucky Aviation LLC · Cincinnati, OHBuilt 1964 · S/N 18255496 N2396SLebeouf Bros Towing LLC · Houma, LABuilt 1979 · S/N R18201337 N2397DQuast George Walter · Hutchinson, MNBuilt 1952 · S/N 20549 N2397GHargis William J · Covina, CABuilt 1958 · S/N 51697 N2397RElevate Air LLC · Sandy, UTBuilt 1964 · S/N 18255497 N2397TSound Approach Aviation LLC · Seattle, WABuilt 1971 · S/N 28-7225070 N2397XDow Todd J · Wasilla, AKBuilt 1965 · S/N 18256297 N2398DHenkelmann David H · Janesville, WIBuilt 1952 · S/N 20550 N2398FHorizon Flying LLC · Wilmington, DEBuilt 1965 · S/N 21058598 N2398XPerry Brian J · Stuart, FLBuilt 1965 · S/N 18256298 N2399DAllison Clay M · San Angelo, TXBuilt 1952 · S/N 20551 N2399FJordan Danny L · Medford, ORBuilt 1965 · S/N 21058599 N2399GJohansson Ronny · Wasilla, AKBuilt 1958 · S/N 51699 N2399TThompson Nolan E · Houston, TXBuilt 1971 · S/N 28-7205052 N239AShiloh Flite Five · Eden, NCBuilt 1996 · S/N 3246022 N239AASlabach Jason M · Winston Salem, NCBuilt 1961 · S/N D-6763 N239ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496038 N239CWolvestown LLC · Humble, TXBuilt 2003 · S/N 2843581 N239CSEversmeyer Larry D · Oklahoma City, OKBuilt 1950 · S/N 19555 N239DGTabares Alain · Zephyrhills, FLBuilt 1968 · S/N TC-1187 N239JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020009 N239MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881868 N239NDPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842100 N239SMelton Michael D · Afton, VABuilt 1965 · S/N D-7893 N239STN239st LLC · Peachtree City, GABuilt 2006 · S/N 3246239 N239SWPyles William J · Pismo Beach, CABuilt 1979 · S/N 24-0924 N239TRosman Patrick R · Creston, WABuilt 1955 · S/N 31775 N239VLomax John E · Powell, TNBuilt 1947 · S/N D-683 N239WMPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1953 · S/N 30383 N23ADBoyd Kirby · Fort Worth, TXBuilt 1951 · S/N 20063

Back to AD 98-21-21 R1