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.

N477ALSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 17701285N477AMSpicher Samuel C Jr · Groveland, FLBuilt 2021 · S/N 28020017N477BGParker Dennis A · Charlevoix, MIBuilt 1977 · S/N AA5A0364N477CHCsi Flight Services LLC · Mcminnville, ORBuilt 2004 · S/N 3729N477DCChildress David W · Coldwater, MSBuilt 2007 · S/N 70717N477DKPhilippi Ranches Inc · Hermiston, ORS/N 2160N477EE477ee LLC · Bethany, OKBuilt 2023 · S/N 172S12954N477GFState Of Alabama Department Of Conservation · Montgomery, ALBuilt 2018 · S/N 18283055N477GYGolf Yankee LLC · Haymarket, VABuilt 2024 · S/N 18283265N477JGulf Airbatics Ltd · Jennings, LABuilt 1966 · S/N TE-108N477LLLima Lima LLC · Lander, WYBuilt 1968 · S/N 18-8755N477LMStampley Michael C · Mount Pleasant, SCBuilt 1965 · S/N 643N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200N477PSSilver Patrick F · Toney, ALBuilt 2016 · S/N 91796N477RRadtke Jeffrey A · Norwalk, CTBuilt 2003 · S/N 3232006N477RBNwl Capital Holdings LLC · Black Eagle, MTBuilt 1974 · S/N D-9685N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477N477RVVans Aircraft Inc · Aurora, ORBuilt 2004 · S/N 71702N477SFAps Asset Management Inc · Mesa, AZBuilt 1999 · S/N 088N477SPRegistration Pending · Leesburg, VARegistration pendingBuilt 2004 · S/N 71402N477TPaetzold Benjamin T · Fort Worth, TXBuilt 1967 · S/N 670274N477UVUtah Valley University · Orem, UTBuilt 2018 · S/N 4496450N477WCAllison Medical Solutions LLC · Lumberton, MSBuilt 1977 · S/N E-1065N4780APenn Flyers LLC · Greensburg, PABuilt 1956 · S/N 22-3931N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115N4780RR&R Flight Services Inc · Mendota, ILBuilt 1975 · S/N 18802319N4780YPhiladelphia Glider Council · Hilltown, PABuilt 1968 · S/N 25-4548N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136N4781DGipe Douglas A · Malvern, IABuilt 1958 · S/N 34881N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116N4781NRobwin Air LLC · Lutz, FLBuilt 1979 · S/N 18267364N4781QStocker Russell · Woodland, CAS/N 18802523N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140N4782DSwalling Matthew C · Wasilla, AKBuilt 1958 · S/N 34882N4782GSeguin Elliot · Rosamond, CABuilt 1968 · S/N 77N4782POlson Allan K · Tarpon Springs, FLBuilt 1960 · S/N 27-338N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204N4783Haire Kenneth H · Star City, ARS/N 93N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006
Back to AD 2007-04-19 R1