OpenAirDocs.org
AD 2001-02-10

Registered aircraft · 261

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-02-10')
    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-02-10')
  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.

N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N100RABonanza Holdings Group LLC · Greenville, NCBuilt 1977 · S/N P405N101AXFogg Britt · Springdale, ARS/N P427N1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N P-78N10GWSereno Re Holdings LLC · Carefree, AZBuilt 1981 · S/N P-570N10WEGear Up Inc · Ramona, CABuilt 1977 · S/N P-428N11141Hoitsma Lynn F · Castlewood, SDBuilt 1980 · S/N P-533N111WKMad-Con LLC · Ijamsville, MDBuilt 1977 · S/N P-439N111XLNova Aircraft Inc · Clearwater, FLS/N P-197N1153SThomas Michael R · Saint Clair, MOS/N P-161N1155TCaljet Aviation LLC · Magnolia, TXBuilt 1969 · S/N P-47N120SPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N P-538N1234ASbm Aviation LLC · Afton, WYBuilt 1980 · S/N P-535N1234LRld Leasing Inc · Downers Grove, ILBuilt 1974 · S/N P-320N123JFAlto Aero LLC · Dover, DEBuilt 1974 · S/N P-284N123NKLarson Ken · Escondido, CABuilt 1970 · S/N P-153N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257N12EUInternational Air Services Inc Trustee · Carson City, NVS/N P582N12PPAero Verde LLC · Wheat Ridge, COBuilt 1975 · S/N P-334N12SRNorthshore Group LLC · Wilmington, DEBuilt 1974 · S/N P-316N14VPAmerican Woodcraft LLC · Fort Denaud, FLBuilt 1981 · S/N P-576N151WARoyal Air Charters · Shreveport, LAS/N P-423N152URoyal Air Inc · Shreveport, LABuilt 1968 · S/N P-14N1551LSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N P-391N157JTWest Pacific Air LLC · Spokane, WABuilt 1982 · S/N P-589N15FMErda LLC · Wilmington, DEBuilt 1979 · S/N P-522N15SYGoldman Richard D · Litchfield Park, AZBuilt 1969 · S/N P-46N15TDRegistration Pending · Chicago, ILRegistration pendingBuilt 1973 · S/N P-232N160CRBas Part Sales LLC · Greeley, COBuilt 1968 · S/N P-24N1642WFreeport Supply Co · Wyandotte, MIBuilt 1972 · S/N P-198N167UDodson International Parts Inc · Rantoul, KSS/N P-99N168SPMadura Mark · Anchorage, AKBuilt 1980 · S/N P-553N16GKMachugh Adam S · Pasco, WABuilt 1970 · S/N P144N178BGSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1978 · S/N P-459N17TKTucker John F · Sheridan, WYBuilt 1978 · S/N P-480N1808SPowell Avionics Inc · Fayetteville, NCBuilt 1981 · S/N P-573N1808WSailaway Management Inc · Wilmington, DEBuilt 1973 · S/N P-215N181BDQualitair LLC · MichelstadtS/N P-563N18245N18245 Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1977 · S/N P-429N1828LTye Boys LLC · Tulia, TXBuilt 1976 · S/N P-385N18400Cohen Ralph S · Marietta, GABuilt 1977 · S/N P-412N1873WDuke Aerospace LLC · Shelbyville, KYBuilt 1973 · S/N P-231N1883LAirflo LLC · Wilmington, DEBuilt 1976 · S/N P-383N1887LEllin Roger E Jr · Naples, FLBuilt 1976 · S/N P-388N188BHJetspeed Solutions LLC · Middletown, DEBuilt 1980 · S/N P-526N195SDN195sd LLC · Senatobia, MSBuilt 1979 · S/N P-494N19BLEthereal Wings LLC · Tucson, AZS/N P-267N200ERRivera Enrique · Longboat Key, FLS/N P394N2025PBas Part Sales LLC · Greeley, COS/N P-476
Back to AD 2001-02-10