AD 75-12-07

Registered aircraft · 338

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

N333ESRebus LLC · Andover, KSS/N 310Q0232N3364LLopez Edwin · Germantown, TNS/N 310Q0784N33VTTjr Aviation LLC · Orefield, PAS/N 310Q0974N350CHFly Bye LLC · Georgetown, DEBuilt 1973 · S/N 310Q0910N350SDAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1970 · S/N 310Q0065N367ATL&R Aircrafts Corp · Boynton Beach, FLBuilt 1972 · S/N 310Q0522N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075N36DLCroll Robert H III · Jacksonville, ORBuilt 1969 · S/N 310P0113N36EWSalzer Dustin J · Weatherford, TXS/N 310Q0521N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671N3TQAbove Blue Line LLC · Austin, TXBuilt 1973 · S/N 310Q0752N3VJMiasnikowicz Victor · Lancaster, PABuilt 1973 · S/N 310Q0746N400WMBryan Craig · Ellisville, MSBuilt 1972 · S/N 310Q0634N40484Sunland Air Inc · Frederick, MDBuilt 1973 · S/N 310Q-0735N4063QThin Air Inc · Hays, KSBuilt 1973 · S/N 310Q0724N414SGCloud Niner Aviation LLC · Zephyrhills, FLS/N 310P0067N417EC417ec LLC · Sheridan, WYBuilt 1972 · S/N 310Q0539N41LCBowen William A III · California, MDBuilt 1972 · S/N 310Q0502N42SSBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 310Q0682N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221N433YHRegistration Pending · Stuart, FLRegistration pendingS/N 310Q0998N4420MJohnson Capital LLC · Colleyville, TXBuilt 1973 · S/N 310Q0808N444STPeterson Ocean Tours LLC · Pace, FLS/N 310Q0605N4546QHarlow Jack M · Benbrook, TXBuilt 1973 · S/N 310Q0728N466QBiziorek Thomas R · Harbor Springs, MIBuilt 1972 · S/N 310Q0534N46CGGlobal Building Investments Inc · Scottsdale, AZS/N 310P0146N46RKAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P0122N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061N497JMBazzi Aviation LLC · Newark, DEBuilt 1972 · S/N 310Q0497N4PJAnderson Richmond E Jr · Orlando, FLBuilt 1972 · S/N 310Q-0515N500RFJones Anthony Blake · Sylacauga, ALBuilt 1968 · S/N 310P0026N533CEHoward David D · Winner, SDBuilt 1969 · S/N 310Q0034N53PTRegistration Pending · Anacortes, WARegistration pendingS/N 310P0126N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220N567Herr John Robert · Saint Petersburg, FLFirst renewal noticeBuilt 1972 · S/N 310Q0459N5701MConsulat Inc · Cheyenne, WYS/N 310P-0001N5709MClear Blue Western Sky LLC · Anthem, AZBuilt 1968 · S/N 310P-0009N5711MSwager Joel P · Ione, CAS/N 310P0011N5712MDay Star Aviation Inc · Locust Grove, GABuilt 1968 · S/N 310P0012N5715MExpress Air LLC · Wilmington, DEBuilt 1968 · S/N 310P0015N5720MSongbird Aviation Inc · Lawrenceville, GABuilt 1968 · S/N 310P0020N5721MWood Michael D · Huntington Beach, CABuilt 1968 · S/N 310P0021N5731MZortman Micky P · Mexico, MOS/N 310P0031N5741MCoolidge Robert · Rio Vista, TXBuilt 1968 · S/N 310P0041N5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 310P0046N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788N5762MNewby Aviation LLC · Pingree Grove, ILBuilt 1968 · S/N 310P0062N5768MHeal Your Heart LLC · Redding, CABuilt 1968 · S/N 310P0068
Back to AD 75-12-07