Registered aircraft · 98

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

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-01-03') 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-01-03') ORDER BY n_number

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-01-03')
    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-01-03')
  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.

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-01-03')
  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-01-03')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1009FDavidson Richard E · Tchula, MSBuilt 2019 · S/N T34-484 N127PBGilland Ag Service LLC · Elkton, TNBuilt 2009 · S/N T65-022DC N1663SSlater Richard J · Maddock, NDBuilt 1981 · S/N R1820-013DC N2068BTri-County Sprayers Inc · Hamlin, TXS/N T45-015 N2136TWalvoord Spraying Service LLC · Hickman, NEBuilt 1998 · S/N G6-148 N2239VNorth Star Aviation Inc · Ulysses, KSS/N G6-144 N2271ZPlane LLC (The) · Grove, OKBuilt 1997 · S/N G6-147 N2530BSlf Air LLC · Bannister, MIS/N R1820006DC N283TATommys Flying Service · Sherrill, ARBuilt 2009 · S/N T34-314DC N3000HNorth Florida Ag Services Inc · Lake City, FLBuilt 2012 · S/N T34-402 N30019O & K Aviation Inc · Newport, ARS/N T45007DC N3004VCarroll Flying Service Inc · Lake Providence, LABuilt 1995 · S/N G6120 N3006CNewkirk Thomas DBA · Garland, NCBuilt 2012 · S/N T34-403 N3043VMccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-422 N3045HPesicka Theodore J · Hermiston, ORBuilt 2013 · S/N T34-411 N3052VFederal Aerial Applicators LLC · Wilmington, DEBuilt 2012 · S/N T34-374 N3055MChorman Spraying LLC · Milton, DEBuilt 2012 · S/N T34-381 N30601Longwood Flying Service Inc · Hollandale, MSBuilt 2012 · S/N T34-400 N3060DMcelwain Russell · Lancaster, KSBuilt 2012 · S/N T34-383 N30620Mccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-407 N3067XSamson Ag Flying LLC DBA · Wilmington, DEBuilt 2006 · S/N T34-278 N3083ZSilverwings Ag LLC · Burlington, COBuilt 1995 · S/N G6-122 N3091RWilde Air Service LLC · Volga, SDBuilt 1992 · S/N G6-107 N3097LWest Central Ag-Air Inc · Fergus Falls, MNBuilt 1991 · S/N G6-101 N3105USherman Aviation Inc · Redmond, ORBuilt 1992 · S/N G6-108 N3153WCe-Air Inc · Argyle, IAS/N G6-124 N318LGLow Go Flyers Inc · Jonesville, LABuilt 2014 · S/N T34-421DC N31941Gasper Air Spray Inc · Crookston, MNBuilt 1995 · S/N T45-008 N3291VShelton Agri Services Inc · Hereford, TXBuilt 1995 · S/N G6-129 N32973Crop Jet Aviation LLC · Gooding, IDBuilt 1995 · S/N T45-009 N32995Frenchman Valley Farmers Cooperative Inc · Imperial, NEBuilt 1996 · S/N T45-013DC N3299KJones Aviation Inc · Biggs, CABuilt 1996 · S/N T45-012 N3300UVanderpool Gary · Alamo, TXS/N G6-139 N331BFMcguire Rob · Saint John, WABuilt 1992 · S/N G6-102 N332BFAdcock Flying Service LLC · Wetumka, OKBuilt 1994 · S/N G6-117 N339LGKingsley Kiman · Miller, MOBuilt 2011 · S/N T34-347DC N4002UWest Central Ag-Air Inc · Fergus Falls, MNBuilt 1999 · S/N G6-151DC N4025PBob Ruhe Ag Service LLC · Leipsic, OHBuilt 1981 · S/N R1820-018DC N40310Sugair LLC · Corpus Christi, TXBuilt 2004 · S/N T65HG-012 N40358Tri-Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N T34-273 N40428H And M Flying Service LLC · Osceola, ARBuilt 2005 · S/N T34-274 N40475Ed-Air Inc · Oaktown, INBuilt 2005 · S/N T65HG-014 N40481Andrews Bruce · Arlington, GABuilt 2005 · S/N T65HG-015G N40699Plane LLC · Grove, OKBuilt 2005 · S/N T65HG-016 N41024Headwaters Flying Service LLC · Three Forks, MTBuilt 2006 · S/N T65HG-020G N4109VArnt Aerial Spraying Inc · Worthington, MNBuilt 2000 · S/N G6-154 N4182GNeidert Melvin Ed · Ulysses, KSBuilt 2000 · S/N G6-155 N447ATJones Aviation Inc · Biggs, CABuilt 1992 · S/N G6-103 N449ATRau Brian C · Medina, NDBuilt 1992 · S/N G6-105 N4592TAurora Cooperative Elevator Co · Aurora, NEBuilt 1992 · S/N T45-003DC

Back to AD 93-01-03