OpenAirDocs.org
AD 93-24-02 R1

Registered aircraft · 806

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

N191AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 31P-7630012N192CSDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300138N195AAAir Travel Management LLC · Lemont Furnace, PABuilt 1978 · S/N 31T7904001N196AGMarc Inc · Bolton, MSS/N 31-7952036N1976JLock Haven Aircraft Sales · Lock Haven, PABuilt 1974 · S/N 31T-7520005N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478N200CXPotter Aviation LLC · Milford, NJBuilt 1984 · S/N 31P-8414042N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124N200PGPanther Enterprises LLC · Fort Myers, FLBuilt 1979 · S/N 31T-7920015N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64N200RARagan William W · North Kansas City, MOBuilt 1974 · S/N 31P7400198N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054N200TSSmith Ironworks Of Alabama LLC · Fort Payne, ALBuilt 1978 · S/N 31T-7804002N200XLCondor Aviation LLC · Bethlehem, PABuilt 1981 · S/N 31T-8166010N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092N20BBSteller Air Charter LLC · Jacksonville, FLBuilt 1983 · S/N 31P-8414005N20LXLockheed Martin Corporation · Palmdale, CABuilt 1975 · S/N 31-7552121N20WLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1976 · S/N 31T-7720011N212KSKilo Sierra LLC · Dodge City, KSBuilt 1979 · S/N 31T-7904010N212RAAbin Ricardo · Miami Lakes, FLBuilt 1977 · S/N 317712057N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126N221ACAusten Air LLC · Lees Summit, MOBuilt 1980 · S/N 31-8152045N222GWDodson International Parts Inc · Rantoul, KSS/N 31T-7904050N225CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N 31T-8104024N225PTCurry Construction Inc · Mattoon, ILBuilt 1981 · S/N 31T-8166032N225TMSouth Of Snow Adventures LLC · Hartwell, GAS/N 318152165N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085N227TMMed Care Inc · Grand Island, NES/N 31T-7400008N22AWAir What What LLC · Clackamas, ORBuilt 1979 · S/N 31T-7920059N22WFBemidji Aviation Services Inc · Bemidji, MNBuilt 1978 · S/N 31T-7920007N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062N233PSDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7820039N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203N234PLCole Steven David · Saint Petersburg, FLS/N 31P-7300147N237PCBlue Water Solutions Inc · Peachtree City, GABuilt 1981 · S/N 31T-8166045N241WFInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852073N242GG242gg LLC · Wilmington, DEBuilt 1979 · S/N 31-7952080N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025N244ABParton Aviation Co LLC · Rutherfordton, NCBuilt 1979 · S/N 31T-8004015N2458WBig Bend Outdoor Center LLC · Pittsburg, TXBuilt 1979 · S/N 31T-8004017N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045
Back to AD 93-24-02 R1