Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N2YEAllied Moulded Products Inc · Bryan, OHBuilt 1975 · S/N 310R0577 N2YROverland Missions Inc · Cocoa, FLS/N U20601737 N2YYRd Enterprises LLC · Blacksburg, SCS/N CD-933 N2ZTwo Zulu LLC · Mclean, VABuilt 1989 · S/N E-2514 N2ZDMelin Lynn Glenn · Scottsdale, AZBuilt 1974 · S/N 18262867 N2ZHClt Thompson Holdings LLC · Charlotte, NCBuilt 2001 · S/N 0056 N2ZWThordarson Gudsteinn Thor · La Porte, INBuilt 1956 · S/N D-4564 N300Texas Sky Masters Inc DBA · Dallas, TXBuilt 1976 · S/N P3370236 N3000DHungy Air LLC · Bettendorf, IABuilt 2001 · S/N 0083 N3000FNosense LLC · Kalispell, MTS/N 34-7970044 N3000QFlying H Enterprises · Santa Fe, NMBuilt 1967 · S/N 18258000 N3000TN3000t LLC · Townsend, GABuilt 1967 · S/N 337-0600 N3000YChesebro Ben D · Tucson, AZBuilt 1962 · S/N 18254000 N3001CHoyt Robert H · Canby, ORBuilt 1958 · S/N D-5664 N30028Cc Aviation Inc · Tracy, CAS/N 34-48019 N3002CAviation By Gosh LLC · Burlington, TXBuilt 1958 · S/N D-5665 N3002QJaeger Christopher E · Normandy Park, WABuilt 1967 · S/N 18258002 N3002WRio Concho Aviation Inc · Weatherford, TXBuilt 1973 · S/N E-453 N3002YGiefer Brett T · Nicollet, MNBuilt 1962 · S/N 18254002 N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879 N3003DRoach James M · West Bountiful, UTBuilt 1955 · S/N 35203 N3003FHassinger Farms LLC · Cove, ORBuilt 1966 · S/N 18257103 N3003L310-J Enterprises Inc · Parkland, FLBuilt 1965 · S/N 310J0003 N3004FN3004f LLC · Cranberry Township, PABuilt 1966 · S/N 18257104 N3005CFodor Vincent A · Doylestown, OHBuilt 1958 · S/N D-5668 N3005FE & E Jones Farms LLC · Munford, ALBuilt 1966 · S/N 18257105 N3005NRoaring Fork Aviation LLC · Snowmass Village, COBuilt 1979 · S/N 28R-7931055 N3005QParadox Designs Inc · Las Vegas, NVBuilt 1979 · S/N 28R-7931024 N3006DWarmkesserl James R · Felton, CABuilt 1955 · S/N 35206 N3006QHarrington Michael L · Twin Falls, IDS/N 18258006 N3006YWissner Martin L · Carpenter, WYBuilt 1963 · S/N 18255082 N3007FTroelstra Frederick D · Queensbury, NYBuilt 1966 · S/N 18257107 N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365 N3008CTech Aero Avionics LLC · Denton, TXBuilt 1958 · S/N D-5671 N3008RPerguson Robert C · Converse, TXBuilt 1962 · S/N 320A0008 N3008YWidmier Kolby J · Price, UTBuilt 1962 · S/N 18254008 N300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1966 · S/N D-8056 N300ASRandall David C · Hermitage, PABuilt 1975 · S/N TC-1908 N300BMohave Maverick Aviation LLC · Bullhead City, AZBuilt 1966 · S/N TC-1001 N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258 N300BWWatson Brent J · Bountiful, UTBuilt 1965 · S/N 18256725 N300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0121 N300CLHustak Michael G · Granbury, TXBuilt 1969 · S/N D-8913 N300DFDowner Justin W · Berthoud, COBuilt 1966 · S/N 18257109 N300EB4031 Pilots LLC · Crown Point, INBuilt 1974 · S/N 310R0082 N300EJPartwin LLC · Greenwich, CTBuilt 1974 · S/N 310Q1156 N300EMMark Thomas Productions LLC · Ketchum, IDBuilt 1966 · S/N 18257529 N300EW2f Trade LLC · Collinsville, TXS/N 21061219 N300GMidwest Partitions Flight Services LLC · Thedford, NEBuilt 2013 · S/N E-3992 N300HCPs Air LLC · Evansville, INBuilt 1983 · S/N 21064804

Back to AD 2000-23-21