OpenAirDocs.org
AD 2000-23-21

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

N3720DHarrington Patrick M · Quitman, MSBuilt 1957 · S/N 34420N3720GPersonal Space Aviation LLC · Nokomis, FLBuilt 1977 · S/N 310R0955N3721QCotter Peter J · Leicester, MAS/N CD-1067N3721UDanko Lawrence G Trustee · Paden, OKBuilt 1963 · S/N 18255121N3722DSkydive Inc · Eagle Creek, ORBuilt 1957 · S/N 34422N3722UDudash George M · Escondido, CABuilt 1963 · S/N 18255122N37236Nay Richard B · Gunnison, UTBuilt 1981 · S/N EA202N37237Hudson Bay Holdings LLC · Lebanon, TNBuilt 1977 · S/N 310R0968N3723DOlsen'S Grain Inc · Chino Valley, AZBuilt 1957 · S/N 34423N3724URouter Bit Service Co Inc · High Point, NCBuilt 1963 · S/N 18255124N37256Patriot Air Inc · Belleville, ILBuilt 1977 · S/N 310R0977N3725DMulhaney James T · Wasilla, AKS/N 34425N3725QHare Lawrence H · Vero Beach, FLS/N CE-135N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N3726L8s1-51 LLC · Polson, MTBuilt 1994 · S/N CE1787N3727DTwo Seven Delta LLC · Meridian, IDBuilt 1957 · S/N 34427N37285Java Air LLC · Visalia, CABuilt 1979 · S/N 340A0953N3728AAc Bonanza LLC · Carrollton, TXBuilt 1969 · S/N D-9084N3728DRoberts Anthony E · Millville, CABuilt 1957 · S/N 34428N3728UMaupin Daniel D · Corvallis, ORBuilt 1963 · S/N 18255128N3728YPrt Aviation Corp · Wilmington, DEBuilt 1963 · S/N 21058228N372ATTitanium Air LLC · Boerne, TXBuilt 2015 · S/N T24002092N372BSchmalhaus Rodney · Garfield, ARS/N D-5101N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372DCSweet Dreams Aviation LLC · Albany, GABuilt 2002 · S/N 1210N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215N372LFShoemaker William · Manns Choice, PABuilt 2004 · S/N 1074N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115N372RVJordan Stephen L · Indian Springs, ALBuilt 2007 · S/N 40372N372VUPerry Robert P · Chelan, WABuilt 1955 · S/N 31428N372WTCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11575N372ZLuy Jonathan Carl · Sutter Creek, CABuilt 1960 · S/N CD-254N37302Elrod Jason A · Seattle, WABuilt 1977 · S/N 340A0334N37306Frescomar USA LLC · Miami, FLS/N 340A0336N3730DLedbetter Jeffrey Allen · Huntley, ILS/N 34430N3730UWarren Kevin · Berger, MOBuilt 1963 · S/N 18255130N37315Atlantic Coast Contractors Inc · Denver, NCBuilt 1977 · S/N 340A0341N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906N3731QMoore J D · Lawson, MOBuilt 1966 · S/N D-8374N3731YHaglin Dana · Erie, COBuilt 1963 · S/N 21058231N3732DClark William M · Ann Arbor, MIBuilt 1957 · S/N 34432N3732QMyers Greg · Amarillo, TXBuilt 1967 · S/N CD-1088N3732UGifford Tracy G · Stephenville, TXBuilt 1963 · S/N 18255132N3733QChalender Robert C · Cocoa, FLBuilt 1967 · S/N TE-294N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233N37343Bearings & Belts LLC · Carlsbad, NMBuilt 1977 · S/N 340A0358N3734DVessey William M · Yuma, AZBuilt 1957 · S/N 34434N3734QInternational Aviation Industries LLC · Kalispell, MTS/N TE-303N37350Price Brenda · Poplar Bluff, MOBuilt 1980 · S/N E-1768N37356Congregation Rosh Hagivah Inc · Waterbury, CTBuilt 1977 · S/N 340A0364
Back to AD 2000-23-21