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.

N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157 N2357TB & R Aviation LLC · Pine Knoll Shores, NCBuilt 1961 · S/N NAV-4-2357 N2357XScavera Kevin · Madras, ORBuilt 1965 · S/N 18256257 N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889 N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558 N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827 N2358TNewcom Bradly C · Hanson, KYBuilt 1961 · S/N NAV-4-2358 N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559 N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159 N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459 N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259 N235AADifferent Auto LLC · Twin Falls, IDBuilt 1959 · S/N D-5967 N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134 N235DLPegasus Royalty Group LLC · Bozeman, MTBuilt 2006 · S/N 41571 N235DRJones Mark A · Litchfield Park, AZBuilt 1985 · S/N 25-0889 N235DWAir 4 LLC · Oakland, MES/N 41766 N235EMcfarland Joel Cable · East Earl, PABuilt 1963 · S/N D-7162 N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443 N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526 N235JARabosky Gary · Frenchtown, NJBuilt 2008 · S/N 411102 N235JLKm Aero Holdings LLC · Wilmington, DEBuilt 2006 · S/N 41701 N235RRegistered aircraftBuilt 1966 · S/N D-8360 N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446 N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326 N235SEPlane Flt LLC · Broken Arrow, OKBuilt 1981 · S/N E-1953 N235SKInde Aviation LLC · Chesterfield, VABuilt 2023 · S/N 9372 N235SLNce Inc · Tucson, AZBuilt 2007 · S/N 41746 N235SMTriniair LLC · Warner Robins, GAS/N TH-926 N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206 N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797 N235WTNelson John R · Bedford, NHBuilt 2023 · S/N 9061 N2360Adams Courtney E · Tampa, FLS/N 0100 N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088 N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660 N2360GVath Edward V · Acton, CABuilt 1958 · S/N 51660 N2360JReed Matthew A · Burnsville, MNBuilt 1963 · S/N CD-698 N2360TAerojet Sevices Inc · Aurora, COBuilt 1961 · S/N NAV-4-2360 N23612Lcms Limited · Durham, NCBuilt 1977 · S/N CE-756 N23614Great American Jet Inc · Cincinnati, OHBuilt 1978 · S/N TC-2153 N23615Yoder Metal & Post Frame & Building Supplies · Haven, KSBuilt 1977 · S/N E-1191 N2361GMcmanigle Jeffrey M · Osakis, MNBuilt 1958 · S/N 51661 N23620Erickson Brian C · Pahrump, NVBuilt 1977 · S/N E-1165 N23621Excellance Inc · Madison, ALBuilt 1977 · S/N E-1192 N2362RBarone Christian · Stratham, NHBuilt 1964 · S/N 18255462 N2362SMclaren Institute Of Transporation Technologies · Goode, VABuilt 1967 · S/N 337-0662 N2362XFort Scott Family Medicine Pa · Fort Scott, KSBuilt 1965 · S/N 18256262 N23639Teleprint Inc · Rydal, PABuilt 1978 · S/N E-1293 N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563 N2363GSawaya Mark C · Spring Valley, CABuilt 1958 · S/N 51663 N2363RVertikle Enterprises LLC · Cheyenne, WYBuilt 1964 · S/N 18255463

Back to AD 2000-23-21