Registered aircraft · 85,612

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.

N2608ZKaufield John E · Garden Prairie, ILBuilt 1981 · S/N 27-8154015 N2609LHavertown Flyers LLC · Havertown, PABuilt 1967 · S/N 17255809 N2609QDawson Arden H III · Eagle Nest, NMBuilt 1966 · S/N 18257809 N2609VPallotto Victor N · Passaic, NJBuilt 1948 · S/N 18119 N2609YHelvey Michael H · Sheridan, WYBuilt 1962 · S/N 18051109 N260AACarpenter Timothy A · Phoenix, AZBuilt 1966 · S/N D-8325 N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436 N260BBDutchess Community College Foundation · Poughkeepsie, NYS/N 32-7400045 N260BCFlying J LLC · Bulverde, TXBuilt 1967 · S/N 24-4606 N260CJohnson Thomas G Jr · Morganton, NCBuilt 1965 · S/N 28-10680 N260CDMarlow Bruce D - Trustee · Nevada City, CABuilt 1966 · S/N 24-4389 N260CSRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1975 · S/N 32-7500022 N260DFMatchbox Holdings LLC · Harrisonburg, VABuilt 1975 · S/N 18264479 N260DTInternational Air Services Inc Trustee · Carson City, NVS/N 24-4995 N260EABlue Sky Airfleet LLC · Kalispell, MTBuilt 2004 · S/N E-3408 N260FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020258 N260FHFlorida Flyers · Jacksonville, FLBuilt 1965 · S/N 32-54 N260FLFox Leasing Group LLC · Hollywood, FLBuilt 2023 · S/N 4496563 N260GCFeline Health Inc · Hampstead, NCBuilt 1969 · S/N 24-4834 N260GPJs Doig Restoration LLC · Varnville, SCBuilt 1967 · S/N 32-873 N260JFKropp Christian Trustee · Azle, TXBuilt 1965 · S/N 24-4196 N260NCYounhorsh Sales LLC · Wilmington, DEBuilt 1969 · S/N 24-4855 N260NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842055 N260PCRegistered aircraftBuilt 1965 · S/N 24-4125 N260PTPeterson Todd · El Dorado, KSBuilt 1977 · S/N 18265612 N260SCN260sc Partnership Group LLC · Ogden, UTBuilt 1964 · S/N 24-3678 N260STPitts S2b LLC · Salinas, CABuilt 1981 · S/N 34-8133047 N260SWMattson Krister T · Onalaska, WIBuilt 1966 · S/N 32-541 N260TGPickerel Enterprises LLC · Bennet, NES/N 18267521 N260UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020225 N260WGRegistered aircraftBuilt 1968 · S/N 32-1039 N2610Avionicos Corp · Nokomis, FLBuilt 1977 · S/N 34-7770428 N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010 N2610DKomer Thomas B Jr · Moorpark, CABuilt 1952 · S/N 20762 N2610RStable Aviation LLC · Eagan, MNBuilt 1969 · S/N 28R-35229 N2611DAmsdell David A · Morgantown, WVS/N 20763 N2611FMccall Aviation LLC · Union Springs, ALBuilt 1965 · S/N 18256711 N2611MOlsen Robert F · Chatham, MABuilt 1977 · S/N 28R-7803138 N2612QLabarre Ben A · Hayward, WIS/N 18257812 N2612UNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17250212 N2612XMcnutt Brian K · Dillon, MTBuilt 1965 · S/N P206-0112 N26132Active Pilot Solutions Inc · Van Nuys, CABuilt 1975 · S/N 28-7515443 N2613CThree Two Five Echo Fc · Corinth, TXBuilt 1985 · S/N E-2293 N2613DBentley Chase · Dry Ridge, KYBuilt 1952 · S/N 20765 N2613FHowe Justin · Encampment, WYBuilt 1965 · S/N 18256713 N2613LOzark Aviators Inc · Willow Springs, MOBuilt 1967 · S/N 17255813 N2613SLow Wing Aviation LLC · Mountain Home, ARBuilt 1976 · S/N 21061340 N2613UHill Richard W · Salem, ORBuilt 1963 · S/N 17250213 N2613WAnderson Raymond O · Bismarck, NDS/N 959 N2614FWissenbach Richard G · Pinesdale, MTBuilt 1965 · S/N 18256714

Back to AD 98-21-21 R1