OpenAirDocs.org
AD 75-06-09

Registered aircraft · 75

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-06-09')
    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-06-09')
  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.

N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N P-78N111XLNova Aircraft Inc · Clearwater, FLS/N P-197N1153SThomas Michael R · Saint Clair, MOS/N P-161N1155TCaljet Aviation LLC · Magnolia, TXBuilt 1969 · S/N P-47N123NKLarson Ken · Escondido, CABuilt 1970 · S/N P-153N152URoyal Air Inc · Shreveport, LABuilt 1968 · S/N P-14N15SYGoldman Richard D · Litchfield Park, AZBuilt 1969 · S/N P-46N15TDRegistration Pending · Chicago, ILRegistration pendingBuilt 1973 · S/N P-232N160CRBas Part Sales LLC · Greeley, COBuilt 1968 · S/N P-24N1642WFreeport Supply Co · Wyandotte, MIBuilt 1972 · S/N P-198N167UDodson International Parts Inc · Rantoul, KSS/N P-99N16GKMachugh Adam S · Pasco, WABuilt 1970 · S/N P144N1808WSailaway Management Inc · Wilmington, DEBuilt 1973 · S/N P-215N1873WDuke Aerospace LLC · Shelbyville, KYBuilt 1973 · S/N P-231N22KJb Earthmoving Equipment LLC · Lemont Furnace, PAS/N P-51N23PLNewsome Jeff · Blackwell, OKBuilt 1970 · S/N P-128N2883WAustin Richard K · Ludington, MIBuilt 1973 · S/N P-238N2GPPlanes Of Fame Air Museum · Chino, CAS/N P-56N3036WSpowart James F DBA · Huntington Beach, CABuilt 1973 · S/N P-236N306QCAmerican Woodcraft LLC · Labelle, FLBuilt 1972 · S/N P-190N311ANValiair Ltd Co Trustee · Casper, WYBuilt 1970 · S/N P-141N311NSimmons Calvin L · Peralta, NMBuilt 1970 · S/N P-130N326TCAlvarado Ruben Jr · Brownsville, TXBuilt 1969 · S/N P-121N335DLarson Ken · Lake Havasu City, AZS/N P-129N33WFReardon Randy L · Sedalia, COBuilt 1971 · S/N P-168N345YWImpact Real Estate Group LLC · Casper, WYBuilt 1969 · S/N P-85N360AKLindquist Scott DBA · Minnetonka, MNBuilt 1968 · S/N P-18N38NHendrix Stuart Brent Trustee · Atascadero, CABuilt 1973 · S/N P-220N3984Epstein Steven D · Vallejo, CABuilt 1970 · S/N P-147N399TLWilson Aircraft Inc · Independence, MORegistration revokedBuilt 1969 · S/N P-54N400BPCole Gary · Richmond, TXBuilt 1969 · S/N P-96N402JSShelco Investments LLC · Las Vegas, NVBuilt 1971 · S/N P175N40DDReceptacle Ministries · Blackshear, GABuilt 1973 · S/N P-239N43HDEastern Shore Aviation LLC · Lebanon, PABuilt 1970 · S/N P-149N4445WHendrix Todd M · Bakersfield, CABuilt 1973 · S/N P-245N44WReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N P-29N48GCRoyal Air Inc · Shreveport, LABuilt 1970 · S/N P167N505GEWgm Solutions LLC · Mart, TXBuilt 1971 · S/N P-186N523HCN523hc LLC · Pinecrest, FLBuilt 1972 · S/N P-200N54DBMattingly Aviation LLC · Radcliff, KYBuilt 1970 · S/N P-127N55CLBoyd Larry C · Seymour, TXBuilt 1969 · S/N P-77N55VVMcnitt Todd M · Newport, ORBuilt 1968 · S/N P-20N5888LDavenport Aviation LLC · Rock Hill, SCS/N P-89N60CLJubjub LLC · Shawnee, KSBuilt 1972 · S/N P-201N60PFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N P-87N60RKMajeste Air LLC · Reno, NVBuilt 1969 · S/N P-79N666XGolden Eagle LLC · Estero, FLBuilt 1973 · S/N P-234N68CRAeronation Aircrft & Exotics LLC · Lewes, DEBuilt 1972 · S/N P-211N68EBGayler Larry G · Thermal, CABuilt 1972 · S/N P-207
Back to AD 75-06-09