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.

N5111SC And A Aviation Inc · Baltimore, MDBuilt 1971 · S/N 28-7105130N5112LRyan Lowe Aviation · Costa Mesa, CABuilt 1967 · S/N 28-4394N5113LTessos Air Service Inc · Wilmington, DEBuilt 1968 · S/N 28-5083N5114LHenry Lawrence D · Lohman, MOBuilt 1967 · S/N 28-4397N5116LLits LLC · Bowling Green, KYBuilt 1967 · S/N 28-4399N5116SWizco Company LLC · Norfolk, NEBuilt 1971 · S/N 28-7105169N5117LEmery Jonathan D · Payson, AZBuilt 1967 · S/N 28-4400N5117WJorgensen-Tjorneho Erik R · Conroe, TXBuilt 1961 · S/N 28-142N5119WLe Thanh Q · Santa Ana, CABuilt 1961 · S/N 28-144N511RFOlson Dean W · Shelbyville, KYBuilt 1971 · S/N 28-7105167N5120GGoering Vincent R · Hephzibah, GABuilt 1968 · S/N 28-4937N5120LClifford Scott P · Wallkill, NYBuilt 1967 · S/N 28-4403N5120SIntentus Aviation LLC · Sunset, TXBuilt 1971 · S/N 28-7105171N5121GWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 28-5005N5121SSandmann Ross · Plano, TXBuilt 1971 · S/N 28-7105175N5121WCarroll Thomas F · Independence, MOBuilt 1961 · S/N 28-146N5122LJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1967 · S/N 28-4405N5122SKudla Frank R · Bean Station, TNBuilt 1971 · S/N 28-7105172N5122WSale Reported · Cape Elizabeth, MESale reportedBuilt 1961 · S/N 28-148N5124LCrisp Phil · Greencastle, PABuilt 1967 · S/N 28-4407N5125WElyon Holdings LLC · Gulf Shores, ALBuilt 1961 · S/N 28-151N5126LMccoy Jiro · Fort Walton Beach, FLBuilt 1967 · S/N 28-4409N5126SRyan Kevin M · Xenia, OHBuilt 1971 · S/N 28-7105173N5127GKurtz Joseph A · Hamilton, GAS/N 28-24675N5127SWeston Thomas J · Stratford, NJBuilt 1971 · S/N 28-7125457N5128GSale Reported · Gainesville, FLSale reported, pending cancellationBuilt 1968 · S/N 28-24669N5128LSquawk 2017 LLC · Flowery Branch, GABuilt 1967 · S/N 28-4411N5128SDonegan Martin A O · Bethlehem, PABuilt 1971 · S/N 28-7125512N5129SSplendid Aviation Inc · Corpus Christi, TXBuilt 1971 · S/N 28-7125600N5129WStanek Kenneth W Jr · Russellville, ARBuilt 1961 · S/N 28-156N512FLReiley Allen Ted · Lavernia, TXBuilt 1971 · S/N 28-7125336N512PTHigh Performance Aircraft LLC · El Cajon, CABuilt 1973 · S/N 28-7305101N5130LSalisbury Gershom · Prescott, AZBuilt 1967 · S/N 28-4413N5130WMccutcheon Ernest Thomas · Ninety Six, SCBuilt 1961 · S/N 28-157N5131LSkipper Up LLC · Herron, MIS/N 28-4414N5131WArias Timothy R · Tempe, AZBuilt 1961 · S/N 28-158N5132LMongare Job · Athens, TXBuilt 1967 · S/N 28-4415N5132SFightin Fourth Line Pilots LLC · Gig Harbor, WABuilt 1971 · S/N 28-7105176N5132WSmith Dale S · Grass Valley, CABuilt 1961 · S/N 28-161N5133LBiederman Clifton E · Jasper, FLBuilt 1967 · S/N 28-4416N5133SMcclelland Kip · Douglas, GABuilt 1971 · S/N 28-7105177N5134LPmd Services LLC · Wilmington, DEBuilt 1967 · S/N 28-4417N5135LBolden Robert P · Uvalda, GABuilt 1967 · S/N 28-4418N5135SThompson Eric H · Tucson, AZBuilt 1971 · S/N 28-7125467N5136LBerkowitz Bruce · Poughkeepsie, NYBuilt 1967 · S/N 28-4419N5137LSky Vector LLC · Rustburg, VABuilt 1967 · S/N 28-4421N5137WKrehbiel Timothy M · Holt, MOBuilt 1961 · S/N 28-166N5138LFlying Gators Inc · Overland Park, KSBuilt 1967 · S/N 28-4422N5138SBarr Jerry L Jr · Mount Pleasant, TXBuilt 1971 · S/N 28-7125532N5139LBrown Robert F · Sugarloaf Key, FLBuilt 1968 · S/N 28-4423
Back to AD 96-10-01 R1