OpenAirDocs.org
AD 2000-23-21

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
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.

N180FJDrews Kelly R · Lakeville, MNBuilt 1977 · S/N 18052900N180FKWinter Triangle LLC · Greenland, NHBuilt 1968 · S/N 18051920N180FLDga Aviation LLC · Sacramento, CABuilt 1956 · S/N 32591N180FMTaylor William E Jr · Escanaba, MIBuilt 1974 · S/N 18052499N180FNRivet Inc Trustee · Wilmington, DEBuilt 1981 · S/N 18053201N180FPJunker Dean D · Avoca, IABuilt 1977 · S/N 18052917N180FSShea Frank R · Colchester, VTBuilt 1954 · S/N 31068N180FTJohnson John J · Wasilla, AKBuilt 1954 · S/N 31083N180GBAlbrecht Romaine C · Ohio, ILBuilt 1953 · S/N 30498N180GEStuber Thomas J · Marysville, WABuilt 2010 · S/N 81913N180GHAbbott Christopher J · Gordon, NEBuilt 1965 · S/N 18051607N180GLRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051203N180GMMarquiss Gary C · Gillette, WYBuilt 1957 · S/N 32967N180GPSafstrom Jon S · Duluth, MNS/N 50184N180GRSkie Aero · Campbell, CAS/N 50664N180GTHayes Kurt L · Norman, OKBuilt 1955 · S/N 31456N180HCHerbst Edward J · Las Vegas, NVBuilt 1978 · S/N 18052953N180HDRoper Philip D · Wasilla, AKBuilt 1953 · S/N 30104N180HKChina Pilot Inc Trustee · Wilmington, DEBuilt 1981 · S/N 18053191N180HRRoberts Leon Thomas Trustee · Noxon, MTBuilt 1966 · S/N 18051633N180HSJones Van W II · Wilmington, OHBuilt 1975 · S/N 18052597N180HVVansoestbergen Harry J · Lincoln University, PABuilt 1955 · S/N 31551N180HXPompeo Nancy Lyn · Weymouth, MABuilt 1966 · S/N 18051706N180JNorton L Thomas · North Fort Myers, FLS/N 18051757N180JAAnderson A James · Shady Shores, TXBuilt 1957 · S/N 50002N180JCBirds Boat Livery Inc · Raquette Lake, NYBuilt 1975 · S/N 18052644N180JDMerritt Jerome E · Oroville, CAS/N 32144N180JE8810 Capital Holdings LLC · Jupiter, FLBuilt 1974 · S/N 18052451N180JFAlexander Andrew B · Anchorage, AKBuilt 1953 · S/N 30631N180JHKlein Flying Service · Lawrenceville, ILBuilt 1955 · S/N 31702N180JJOflanagan Clancy H · Chowchilla, CAS/N 18052607N180JKForbes James A · Monkton, MDBuilt 1980 · S/N 18053173N180JLHicks Carl Jr · Gig Harbor, WABuilt 1957 · S/N 32858N180JMN180jm LLC · Joplin, MOBuilt 1957 · S/N 50121N180JPMcmanamin John P · Anchorage, AKBuilt 1955 · S/N 31630N180JSTakakjian Kyle · South Chatham, MABuilt 1976 · S/N 18052723N180JTSproul Andrew W · Isabella, OKFirst renewal noticeBuilt 1955 · S/N 31473N180JVBf Aviation LLC · Boulder, COBuilt 1953 · S/N 30136N180JWStage One Associates LLC · Oxford, CTBuilt 1976 · S/N 18052751N180JZZehm John R · Breezy Point, MNBuilt 1970 · S/N 18052165N180KALofstedt Trever L · Scottsdale, AZBuilt 1972 · S/N 18052263N180KCThompson Robert M · Chandler, AZBuilt 1980 · S/N 18053141N180KEWerth Daniel · Anchorage, AKBuilt 1962 · S/N 18051166N180KKKrentsa Kenneth F · Stockbridge, MAFirst renewal noticeBuilt 1958 · S/N 50401N180KMLone Eagle Aviation LLC · Wilmington, DEBuilt 1979 · S/N 18053052N180KNDavis Brian L · Phoenix, AZBuilt 1973 · S/N 18052358N180KPPerhus Kelly E · Kindred, NDBuilt 1955 · S/N 31285N180KWBadger Brothers LLC · Houston, TXBuilt 1968 · S/N 18051933N180LLietz Terry · Peshastin, WABuilt 1955 · S/N 31450N180LCLincoln David M · Renton, WABuilt 1964 · S/N 18051483
Back to AD 2000-23-21