OpenAirDocs.org
AD 2001-07-11

Registered aircraft · 472

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

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140N100WNColumbus State Community College · Columbus, OHBuilt 1979 · S/N 288N101AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 36-008N101VSCalspan Corporation · Buffalo, NYBuilt 1969 · S/N 218N102VSCalspan Corp · Buffalo, NYBuilt 1974 · S/N 180N103JLThunderun Aviation Corp · Buffalo, NYBuilt 1990 · S/N 026N103TDTrigger Air LLC · Wilmington, DES/N 31-006N107RMDierolf Robert Scott · Carrollton, TXBuilt 1982 · S/N 362N108FLWyoming Aviation Specialist Inc · Green Valley, AZS/N 300N108JNPremier Jets Inc · Hillsboro, ORBuilt 1980 · S/N 35A-358N108RBAerotrust Services Corp Trustee · Wilmington, DEBuilt 1976 · S/N 097N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015N10GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 010N10VJVenture Jets LLC · Lititz, PABuilt 1990 · S/N 018N111FNBest Aircraft Deals LLC · Salt Lake City, UTS/N 293N111KRLs 464 LLC · Colorado Springs, COBuilt 1981 · S/N 464N116MAFsa Aerospace Inc Trustee · Wilmington, DEBuilt 1977 · S/N 029N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084N11GJGlobal Jetcare Inc · Brooksville, FLBuilt 1981 · S/N 425N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342N125FSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1996 · S/N 125N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212N129TKBankair Inc · West Columbia, SCBuilt 1979 · S/N 253N12FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 016N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278N132LJAery Aviation LLC · Wilmington, DEBuilt 1977 · S/N 032N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335N136DHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 036N136JPCasmos LLC · Wilmington, DES/N 35A-359N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139N143CKWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 143N143LJBchjet3 LLC · Greer, SCS/N 143N154RTRise Aircraft 3 LLC · Tomball, TXBuilt 1998 · S/N 154N155ERAir Medical Services LLC · Denver, NCBuilt 1984 · S/N 55-098N155SJLopez Fabio · Denver, NCBuilt 1984 · S/N 102N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024N160GCC2d LLC · Cartersville, GAS/N 36A-030N163CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 163N165CMUS Crane LLC · Wilmington, DES/N 355N166PCTechnical Education Services Inc · Virginia Beach, VABuilt 1970 · S/N 166N16FNGh Equipment LLC · Dover, DEBuilt 1976 · S/N 027N16LJLear Holding Corp · Wilmington, DEBuilt 1986 · S/N 126N171ARThunderun Aviation Corp · Buffalo, NYBuilt 1999 · S/N 171N175FSJet Set 1 LLC · Kalispell, MTBuilt 1965 · S/N 031N178AMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 144
Back to AD 2001-07-11