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.

N7951QClifton James Dvid · Manchester, TNBuilt 1972 · S/N 310Q0672N7953QGoodin David J · Yerington, NVBuilt 1972 · S/N 310Q0673N7960QHartwig Donald J · Riverside, CAS/N 310Q0679N7972QJett Aviation LLC · Success, ARS/N 310Q0681N7997QSilva Robert L · Bakersfield, CABuilt 1972 · S/N 310Q0685N799JBNiner Jay Bee Aviation LLC · Middletown, DEBuilt 1970 · S/N 310Q0097N799TEEaster John E II · Bremo Bluff, VAS/N 310P-0004N79RJDelp Gregory E · Woodbury, CTBuilt 1968 · S/N 310P0055N7LLBautista Sean P · Reedley, CABuilt 1974 · S/N 310Q1019N7WKAll Above Town Ltd · Wilmington, DES/N 310Q0426N800MGSnell Marion Lea · Ackerly, TXBuilt 1974 · S/N 310Q0937N8034QGoins Plastic Source Inc · Texarkana, ARBuilt 1973 · S/N 310Q0691N8133QFinnan-Johnson Flying Club LLC · Woodinville, WABuilt 1972 · S/N 310Q0626N8166QE S P Aviation LLC · Wilmington, DEBuilt 1972 · S/N 310Q0633N8184QJohn Richard A · Southwest Ranches, FLBuilt 1972 · S/N 310Q0636N81RTN81rt LLC · Middlebury, CTBuilt 1973 · S/N 310Q0742N8242QBirds Eye View Inc · Farmington, NMBuilt 1973 · S/N 310Q0715N825GSRed River Ranch LLC · Wilmington, DEBuilt 1972 · S/N 310Q0510N831CPConstant Pleasure LLC · Paso Robles, CAS/N 310Q0813N850KFInternational Air Services Inc Trustee · Carson City, NVS/N 310Q-0041N85BGIsley Aviation Inc · Fort Myers, FLBuilt 1974 · S/N 310Q1068N85SRMccorkle Air LLC · Wilmington, DEBuilt 1974 · S/N 310Q0903N88JBJr Aviation LLC · Benton, KSBuilt 1969 · S/N 310P0174N88LTRyan M Kearbey Dental Corp · Oroville, CABuilt 1973 · S/N 310Q0835N8EPN8ep LLC · Spring Hill, FLBuilt 1973 · S/N 310Q0967N8TCSvenningsen Joshua J · Spring Hill, FLS/N 310Q0264N9110VSmith Stephen R · Lake City, FLBuilt 1969 · S/N 310P-0167N91EHChristensen Del S Trustee · Friendswood, TXBuilt 1974 · S/N 310Q1132N923DPOlson Richard N · Vashon, WABuilt 1974 · S/N 310Q1031N923TAHuelsebusch Travis · Canal Winchester, OHS/N 310Q1008N92ESMarion Hill Associates Inc · New Brighton, PABuilt 1971 · S/N 310Q0049N9915FKeith William F · Bakersfield, CABuilt 1973 · S/N 310Q0719N9920FSmith Glenn A · Horseshoe Bay, TXBuilt 1972 · S/N 310Q0483N9921FReap Aviation LLC · Radford, VABuilt 1972 · S/N 310Q0484N9923FLlm Technology LLC · Austin, TXBuilt 1973 · S/N 310Q0722N9924FMontemayor Rodrigo · Mcallen, TXBuilt 1973 · S/N 310Q0723N999HDEscobar Juan Carlos · Juncos, PRS/N 310Q0463N9AMHangen Mark C · Flagstaff, AZBuilt 1969 · S/N 310P0196
Back to AD 75-12-07