Registered aircraft · 47,133

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.

N475TZVan Bortel Aircraft Inc · Arlington, TXBuilt 2015 · S/N T24002075 N47605Lovaas Darryl G Trustee · Crescent City, CABuilt 1977 · S/N 28R-7703406 N4760EYoung John L · Glorieta, NMBuilt 1982 · S/N 18268269 N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821 N4761CForbis Aviation LLC · Calera, OKBuilt 1979 · S/N 21063617 N4761DNordstrom Anne D Trustee · Walpole, NHBuilt 1958 · S/N 34861 N4761EDorsheimer Ryan J · Camp Hill, PABuilt 1982 · S/N 18268270 N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292 N4761QMichaelson Lawrence · Big Lake, AKBuilt 1967 · S/N 185-1226 N4762BAllen Kenneth W · Anchorage, AKBuilt 1955 · S/N 31660 N4762EFly185 LLC · Estes Park, COBuilt 1979 · S/N 18503868 N47631Ordway Daniel F · Corona, CABuilt 1977 · S/N 34-7770420 N47632Famalette Christopher · Havre De Grace, MDBuilt 1977 · S/N 28R-7703367 N4763EZimmerman Steven W · Olathe, KSBuilt 1951 · S/N 23317 N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938 N4763NBathum Dale · Ketchum, IDS/N 18267346 N4763UCopper River Airmotive LLC · Copper Center, AKBuilt 1964 · S/N 18051463 N47642Wes Hughes Corporation · Waldron, KSBuilt 1977 · S/N 28R-7703413 N47645Arizona Type Ratings LLC · Sedona, AZBuilt 1980 · S/N 340A0992 N4764BPratt Sean · Hampton, NHBuilt 1977 · S/N 18503371 N4764MSpooner James Leonard · Carlisle, PAS/N CE-782 N4764NWhite Robert H · Eagar, AZBuilt 1979 · S/N 18267347 N4764QShapiro David · Homer, AKBuilt 1967 · S/N 185-1230 N4764URegistered aircraftBuilt 1965 · S/N 18051464 N4764YOk3wire Properties LLC · Pensacola, FLBuilt 1973 · S/N D-9418 N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940 N4765QDigger Dougs Crop Dusting Services Inc · Salem, WIBuilt 1976 · S/N 18802513T N4766DHutchison Frank J · Tucson, AZBuilt 1958 · S/N 34866 N4766EWillard Raymond C · Wasilla, AKBuilt 1979 · S/N 18503872 N4766MFx5 Construction & Excavation Inc · Decatur, TXBuilt 1978 · S/N E-1259 N4766UMoore Murray H · Twain Harte, CABuilt 1964 · S/N 18051466 N47670Stanberry Wallace A · Shreveport, LABuilt 1977 · S/N 34-7770424 N4767DFulton Daniel M · Blacksburg, SCBuilt 1958 · S/N 34867 N4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORBuilt 1979 · S/N 18267350 N4767UDeckload Aviation LLC · Kodiak, AKBuilt 1979 · S/N U20605091 N47681C Mf Inc · Bloomington, ILBuilt 1977 · S/N 28R-7703421 N47682Byerly James · Virginia Beach, VABuilt 1977 · S/N 28R-7703422 N4768BEversole Eric L · Kent, WABuilt 1955 · S/N 31666 N4768DBoyd Amy L · Kila, MTBuilt 1958 · S/N 34868 N4768FZankiz Jose Carlos · Naples, FLS/N P206-0368 N4768KJohnson Durwood · Beaumont, TXS/N P21000299 N4768NTreadwell Dennis A · El Cajon, CABuilt 1979 · S/N 18267351 N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101 N4769BNesbett David A Trustee · Anchorage, AKBuilt 1955 · S/N 31667 N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300 N4769NTurner Luke · Mineral Wells, TXBuilt 1979 · S/N 18267352 N476DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1818 N476DWSkylane Capital Group LLC · Seattle, WABuilt 1980 · S/N 18267793 N476EWWny Air Inc · Dover, DEBuilt 1996 · S/N TH-1797 N476JBArchipelago Group LLC · Alexandria, VABuilt 1977 · S/N 28R-7703419

Back to AD 2000-23-21