OpenAirDocs.org
AD 2012-03-07

Registered aircraft · 62,071

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:2012-03-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:2012-03-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.

N100LDPenning Jeffrey D · Clear Lake, IABuilt 1968 · S/N 17700990N100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186N100MVBensen John A · Greenville, NYBuilt 1972 · S/N 11972N100NTBk Aviation LLC · Reno, NVBuilt 2005 · S/N 60438N100PPExplore Helicopters LLC · Lexington, ALBuilt 1975 · S/N 412N100PTJacobs Brian E · Aptos, CABuilt 1997 · S/N 2110N100QRichmond Suzanne L · North Hills, CABuilt 1971 · S/N KL-2N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185N100RFN100rf Ghost LLC · Burleson, TXS/N MB580N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551N100RVMaule Group Ltd · Wilmington, DES/N 20029CN100SQBowles Chris · Taylorsville, NCBuilt 2018 · S/N 90359N100SVKretschman Thomas J · Verona, WIBuilt 1946 · S/N 526N100SXKing Samuel E · Battle Mountain, NVBuilt 1951 · S/N 18-709N100TOwyhee Pacific LLC · Kalispell, MTBuilt 1960 · S/N TD-350N100THWhiddon Mark H · Frankston, TXBuilt 1999 · S/N 001THN100TNMoore Glenn C · Elkhart Lake, WIBuilt 1980 · S/N SS22N100UDVogel Kelly C · Ventura, CAS/N 15070071N100WHTowb Parmalee · Chula Vista, CABuilt 1994 · S/N ONEN100WRBuehler Andrew · Eatonville, WABuilt 1981 · S/N 157N100WWSwearengin David · Lula, GABuilt 1967 · S/N 28-23611N100XXAskew Stell Blake III · Durham, NCBuilt 1975 · S/N AA1B-0578N100YAShelton Joel T · Grass Valley, CAS/N AA5-0086N1010MSimpson Kendal L · Port Orange, FLBuilt 1984 · S/N 119N1010QBurklund Joel H · Minneapolis, MNBuilt 1970 · S/N 27370N1010RKaneair LLC · Hayes, VABuilt 1968 · S/N 591N1011AMachamer John K · Gettysburg, PABuilt 1950 · S/N 18-582N1011LColburn Paul A · Hillsboro, NHBuilt 1960 · S/N 254N1011NBlue Skies Aircraft LLC · Zephyrhills, FLBuilt 1970 · S/N 17259525N1011TPedersen Michael · Bakersfield, CABuilt 1972 · S/N 863-72N1011ZChiappe Richard S · Estes Park, COBuilt 1972 · S/N 0Z-007N1012ASimmons Michael T · Carolina Beach, NCBuilt 1950 · S/N 18-588N1012GForwalt Lucas A · Chesapeake, VABuilt 1969 · S/N AA1-0122N1012JOld School Aircraft LLC · Rogers, MNFirst renewal noticeBuilt 1983 · S/N 1N1013EFouts Chester L · Turner, MTBuilt 1977 · S/N 970-77N1013QCarrera Aviation LLC · Wilmington, DEBuilt 1996 · S/N 21006CN1014EMeade Lance M · Stinson Beach, CABuilt 1977 · S/N 1203-77N1014FPeppard Kenneth W · Dumfries, VABuilt 1979 · S/N 17272931N1014GUpchurch Kenneth A · Baxley, GABuilt 1996 · S/N 20049CN1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650N1014ZMorse Spencer W · Colorado Springs, COBuilt 1970 · S/N 108N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255N1016FFly Cadillac LLC · Tustin, MIS/N 17272932N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315N1017AEllis Wendell K · Gakona, AKBuilt 1950 · S/N 18-587N1017EButtanda Denise · Winchester, VABuilt 1977 · S/N 342-77N1017PZeivogel Jeanine · Gulf Shores, ALBuilt 1954 · S/N 2319
Back to AD 2012-03-07