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.

N102GWJones Jamie M · Grants Pass, ORS/N GW 102N102JTBrady George K · Rose Hill, KSBuilt 1997 · S/N 190N102KCJohnson Jerry D · Bryan, TXBuilt 1982 · S/N 760N102LCMy Technology Services LLC · Miami, FLBuilt 1967 · S/N 28-22860N102LEChabolla Miguel · Tucson, AZBuilt 1981 · S/N 102N102LSVan Dyke Kevin J · Palm Beach Gardens, FLBuilt 1991 · S/N 2844N102LWWulff Allan · Reston, VABuilt 1955 · S/N 18-4383N102LYIves Samuel E · Amarillo, TXBuilt 2003 · S/N 90130N102PFKaehr Lyle · Decatur, INBuilt 1984 · S/N 28-8490042N102PMBrown Scot C · Las Vegas, NVBuilt 2002 · S/N 001N102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462N102RCJohnston Steve M · Lyle, WABuilt 1999 · S/N 1N102RHHayes Ronald O · Blue Springs, MOBuilt 1992 · S/N 1316N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216N102TCMason Brian L · Eagle River, AKS/N 18-7909038N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806N102WRSt Onge Adam R · Sterling, AKBuilt 1952 · S/N 20-919N102ZMann Arthur A III · Cartersville, GABuilt 2019 · S/N 2018-001N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N1030TZamora Milamaedelza · Panorama City, CAS/N 65N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N10329Lissow William M · New Port Richey, FLS/N 22018CN1032JKornegay Kenneth D · Roanoke, VABuilt 1973 · S/N 32N10339Yarbro Floyd A · Kenton, TNBuilt 1997 · S/N 21022CN1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N1034AHawk Don · Shady Cove, ORS/N 18-606N1034ENexga Aircraft Inc · Greensboro, NCBuilt 1977 · S/N 1205-77N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198N1035EJobe Ronald G · Sedalia, MOFirst renewal noticeBuilt 1977 · S/N 983-77N10365Air Heritage Inc · Beaver Falls, PABuilt 1954 · S/N 54-2533N1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035CN1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079N1038EFueston Vernon A · Montague, CABuilt 1977 · S/N 971-77N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552N1039DPetro Jerry R · Williamsburg, VABuilt 1982 · S/N 50N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265N103ACKrueger Douglas K Trustee · Aurora, NEBuilt 1992 · S/N 362-92N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084N103BBHarris John F III · Louisburg, NCBuilt 2000 · S/N 2060N103BCPalmer David M · Jacksonville, ORBuilt 2003 · S/N 448-2003N103BHBeck Randy R · Claremont, CABuilt 2021 · S/N 3C-5C/6C-1613CN103BJKempf Randall P · Crawford, COBuilt 1998 · S/N 1N103BMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 44-8107007N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N103BWWilson Billy C · Fort Worth, TXBuilt 2002 · S/N 21511
Back to AD 2012-03-07