OpenAirDocs.org
AD 75-07-02

Registered aircraft · 2,161

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-07-02')
    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-07-02')
  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.

N100LDPenning Jeffrey D · Clear Lake, IABuilt 1968 · S/N 17700990N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290N10213Sparks Tom · Palestine, ILBuilt 1975 · S/N 17702317N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238N1075MDewitt Scott C · Corpus Christi, TXBuilt 1973 · S/N 177RG0295N107SKFitzpatrick William M · Cleveland, GABuilt 1973 · S/N 17702004N108ATKirschner John R · Crystal Lake, ILBuilt 1971 · S/N 177RG0046N1101CHampton Brock W · Wichita, KSBuilt 1977 · S/N 17702673N1102CWakefield Aviation LLC · Mahopac, NYS/N 17702674N1105CLandon Jeff · Lancaster, CABuilt 1977 · S/N 17702675N110DWSlater Spray Service Inc · Maddock, NDBuilt 1974 · S/N 177RG0495N110PFUniversity Of Detroit Flying Club Inc · Livonia, MIS/N 17702629N11103Hennigan Shellie · Jonesboro, LAS/N 17702325N11172Skaaire Society · Madison, WIBuilt 1975 · S/N 17702327N11226Box Jon A · Carrizo Springs, TXBuilt 1975 · S/N 17702329N11271No Coop Cardinal LLC · Sonoma, CABuilt 1975 · S/N 17702330N112NCFrance Jay D · Colbert, GABuilt 1970 · S/N 17701598N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333N11378Registered aircraftBuilt 1975 · S/N 17702335N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343N11564Ajw Management LLC · Scottsdale, AZBuilt 1975 · S/N 17702347N11566Monterrosa Frank J · Lincoln, CABuilt 1975 · S/N 17702348N11585Registered aircraftS/N 17702349N11596Tagart Charles · Senoia, GAS/N 17702352N11600Nolan James B · Chandler, AZBuilt 1975 · S/N 17702354N11608Aircraft Trade Group LLC · Scandia, MNBuilt 1975 · S/N 17702357N11625Oil Region Aviators LLC · Titusville, PABuilt 1975 · S/N 17702360N1162CReemts Randy G · Alexandria, MNBuilt 1977 · S/N 17702678N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365N11771Boss Gary W · Bronston, KYBuilt 1975 · S/N 17702366N1178COliveira Frank Jr · Pawtucket, RIBuilt 1977 · S/N 17702680N11799Borba Steven D · Woodland, CABuilt 1975 · S/N 17702369N117MMMelton Charlie W · Grand Saline, TXBuilt 1968 · S/N 17700872N11823Redbird LLC · Denver, COBuilt 1975 · S/N 17702370N11825Cardinal Rule LLC · Bryan, TXS/N 17702371N11828Schmitz John J · Jefferson City, MOBuilt 1975 · S/N 17702372N1183CZahorchak Jeffrey G · Harrisburg, PABuilt 1977 · S/N 17702681N1184576 Cessna LLC · Punta Gorda, FLBuilt 1975 · S/N 17702377N1185CSturtevant Roger C Jr · The Villages, FLS/N 17702682
Back to AD 75-07-02