AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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.

N3276DFarkas Jonathan · Mukwonago, WIBuilt 1955 · S/N 32074N3276PFly Rite Aviation LLC · Fort Myers, FLS/N 23-1221N3276SLewinsky Marlon · Carrollton, TXBuilt 1964 · S/N 18255776N3276UNk Innovations LLC · Spokane, WABuilt 1963 · S/N 18254676N32773Dalba Andrew Naim · Anaheim, CABuilt 1974 · S/N 28R-7535088N32779Bcm Enterprise LLC · Phoenix, AZBuilt 1974 · S/N 28-7515238N3277CSandstrom Mark R · Minot, NDBuilt 1978 · S/N R18200264N3277MSmith Carmen Marie · Juneau, AKBuilt 1947 · S/N 12-2134N3277SBayless Smoky · Coronado, CABuilt 1964 · S/N 18255777N3277YLapinsky Richard G · Los Lunas, NMBuilt 1962 · S/N 18254277N3277ZBacklund Scott W · Greybull, WYFirst renewal noticeS/N 22-7229N32781Arends Aviation And Instruction LLC · Mahomet, ILBuilt 1974 · S/N 28-7515239N32783Frederick Michael A · Cleves, OHBuilt 1974 · S/N 28R-7535089N32784Denicola Frank J · Visalia, CABuilt 1974 · S/N 28R-7535090N32785Registration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1974 · S/N 32-7500009N3278SStrong Brian S · Southport, NCBuilt 1964 · S/N 18255778N3278UCarver Thomas G · St Maries, IDBuilt 1963 · S/N 18254678N3278WEvans Jacob · Mona, UTBuilt 1965 · S/N 32-109N32790N32790 LLC · Avilla, INBuilt 1974 · S/N 28-7515242N32793Garrido Albert · Kensington, CTBuilt 1974 · S/N 28-7515243N32794Gilbert Thomas D · Gladstone, MIBuilt 1974 · S/N 28-7505094N32796Mcvey Austin L · Lakewood, COBuilt 1974 · S/N 28-7510030N3279CHunsucker Michael A · Seguin, TXS/N R18200265N3279DDavies James E · Eagle, IDBuilt 1955 · S/N 32077N3279MValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 310R1891N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452N3279PSouth Bay Flight Training Center · Carolina, PRBuilt 1957 · S/N 23-1224N3279USchlafmann Jay R · Mercer, NDBuilt 1963 · S/N 18254679N3279YCrisler Garret · Rice Lake, WIBuilt 1995 · S/N 21942N327ABN327ab LLC · Omro, WIBuilt 2023 · S/N 42127N327AKPearce David W Trustee · Anchorage, AKBuilt 1981 · S/N 18-8109034N327AMSchmidt Steven P · West Springfield, VABuilt 2003 · S/N 0691N327BEBlack Swamp Flyers LLC · Fremont, OHBuilt 2000 · S/N 1296-2000N327BLCinotto Robert L · Rhome, TXS/N TE-1043N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166N327CPSu Farms Transportation LLC · Hale Center, TXBuilt 1973 · S/N 73-30559N327CTYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700535N327DBonanza Flyers LLC · Aurora, COBuilt 1965 · S/N D-7801N327DGSabino Sean · Ames, IAS/N 82766N327DMMullin Clint · Lambert, MTS/N 18262924N327DPZamboni Fisheries LLC · Ketchikan, AKBuilt 2016 · S/N 2010-1N327DTLafferty Jason · Marana, AZBuilt 2004 · S/N 0972N327EDKrejsa David L · Chagrin Falls, OHBuilt 1996 · S/N EB-102-2033N327FFoster Gary R · Mineola, TXBuilt 2000 · S/N 22021N327GSkysix Aircraft Management LLC · Saginaw, MIBuilt 1994 · S/N E-2910N327HBMatthews Michael B · Statesville, NCBuilt 1980 · S/N 221N327HRRd Holdings LLC · Las Vegas, NVBuilt 1979 · S/N 18267468N327LLMeehan Patrick K · Willow, AKBuilt 1999 · S/N 8939N327LSHeermann Philip D · Albuquerque, NMBuilt 1978 · S/N 182-66407N327LWPerini Stephen Dale · Fayetteville, GABuilt 1959 · S/N 52360
Back to AD 2007-04-19 R1