OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596N5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003N5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406N56506Nassour Aviation Inc · Ellisville, MSBuilt 1973 · S/N 28-73-25641N5650USkyways Group LLC · Greensboro, NCBuilt 1969 · S/N 28-26446N5651WHouk David A Jr · Norton, OHS/N 28-834N56521Hawkes Tyler · Rexburg, IDBuilt 1973 · S/N 28-73-25647N56524Registration Pending · West Palm Beach, FLRegistration pendingS/N 28-73-25650N56525Sadi Susan Salimi · Arlington, TXS/N 28-7325651N56536Hurlbut Gary A · Seattle, WABuilt 1973 · S/N 28-7325653N5653UMcclelland Robert C · La Veta, COBuilt 1969 · S/N 28-26449N5653WCrump William J · Williamstown, NJFirst renewal noticeBuilt 1962 · S/N 28-840N5654WHaymes Will · Knoxville, TNBuilt 1962 · S/N 28-815N5655Phillips Mark E · Williamsville, ILS/N 28-3720N56558Onlyfly LLC · Deltona, FLS/N 28-7425004N56559Waggoner Gregory · Woodward, OKBuilt 1973 · S/N 28-7405017N5656WBennett Steven D · Durham, NCS/N 28-821N56573Knuth Matthew · Waupaca, WIBuilt 1973 · S/N 28-7405019N56578Somerset Air Service Inc · Bedminster, NJBuilt 1973 · S/N 28-7325661N5657WMacdonald Kenneth A · Willow, AKBuilt 1962 · S/N 28-822N56580Young Robert L Trustee · Ashland, OHBuilt 1973 · S/N 287325662N5658UTully James W · Clarksville, TNBuilt 1969 · S/N 28-26454N56591Williams Anthony S · Miramar, FLBuilt 1973 · S/N 28-7325664N56592Clw Aviation LLC · Springville, ALBuilt 1973 · S/N 28-7325665N56596Gutowski Michael H · Westfield, MABuilt 1973 · S/N 28-7405021N5659WLeon James M · Frankfort, ILBuilt 1962 · S/N 28-826N56607Arsenault Mark E · Northampton, MABuilt 1973 · S/N 28-7405022N5660UBecker Timothy L · Vail, AZBuilt 1969 · S/N 28-26457N5660WLopez Javier Garcia · San Jose, CABuilt 1962 · S/N 28-865N56617Cherokee N56090 LLC · Jackson, GABuilt 1973 · S/N 28-7325671N56619Rock Water Aviation LLC · Herriman, UTBuilt 1973 · S/N 28-7405023N5661USkyventure LLC · Washington, INS/N 28-26458N5662UBurgin John F · Austin, TXS/N 28-26459N56637Hohenstein Douglas · Spokane, WABuilt 1973 · S/N 28-7325674N5663WCrane Air LLC · Waterford, MIBuilt 1962 · S/N 28-831N56651Boettcher Kurt · Julian, CABuilt 1973 · S/N 28-7405025N5665UZimmerman Damian P · Petersburg, ILS/N 28-26462N5667WBartanowitz Frank · Millwood, GABuilt 1962 · S/N 28-780N56694Bruce Robert · Ormond Beach, FLS/N 28-7425020N5669URollins Seth B · Smithville, MSBuilt 1969 · S/N 28-26466N566FLSarem Daniel J · Spencerville, MDBuilt 1971 · S/N 28-7125409
Back to AD 96-10-01 R1