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.

N5033SGpsp Aviation LLC · Bronx, NYBuilt 1970 · S/N 28R-35762N5033VGarvis Darren G · Livermore, CABuilt 1979 · S/N 1070-79N5033WSapp Jedidiah T · Cordova, AKBuilt 1978 · S/N 1071-79N5034EBurns Joyce A · Sparta, MOBuilt 1958 · S/N 50334N5034GDyson James R · Hilltop Lakes, TXBuilt 1978 · S/N 373-79N5034HHernandez Dorothy V · Juneau, AKBuilt 1975 · S/N 17265309N5034KPiercy Ronald S · Moses Lake, WABuilt 1978 · S/N 1073-79N5034MHood Bruce Allen Jr · Windsor, SCBuilt 1965 · S/N 28-20749N5034NLittle Gregory L · Carnegie, OKBuilt 1979 · S/N 291-79N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N5034SPlattsmouth Aviation LLC · Plattsmouth, NES/N 28R-35801N5034VBibler Barry D · Spearfish, SDBuilt 1978 · S/N 467-79N5034WCurran Robert A · Waldorf, MDBuilt 1978 · S/N 468-79N50350Redline Shane Z · Amarillo, TXBuilt 1978 · S/N 471-79N5035LSteinbauer Timothy · Sandusky, OHBuilt 1971 · S/N 492N5035MFlight World Inc · San Juan, PRBuilt 2001 · S/N 172S8967N5035NCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 470-79N5035QWilfer Dennis M · Fairbanks, AKBuilt 1979 · S/N 292-79N5035SReady Airways LLC · Roseville, CABuilt 1970 · S/N 28R-35766N5035TJettime10 LLC · Grayslake, ILBuilt 1964 · S/N 18255231N5035WHennells Dann · Naples, FLBuilt 1961 · S/N 28-37N5035XAtlantic Arrow Aircraft Inc · Kennesaw, GABuilt 2026 · S/N 172S13522N50361Mcbride Daniel · Burleson, TXBuilt 1979 · S/N 478-79N5036DPfeil Carl A · Mendocino, CABuilt 1958 · S/N 51136N5036GVagias Janet Rose · Niceville, FLBuilt 1979 · S/N 473-79N5036M66ee LLC · Santa Barbara, CABuilt 1978 · S/N E-1255N5036RArctic Winds Inc · King Salmon, AKS/N R18200628N5036SArrow II Flyers LLC · Jacksonville, FLBuilt 1970 · S/N 28R-35804N5036UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N TH-2362N5036WAeroglide Aviation Group LLC · Trenton, NJBuilt 1961 · S/N 28-38N50371Potter Michael J Jr · Fairbanks, AKBuilt 1978 · S/N 283-78N50376Hayes Brad M · Grove, OKBuilt 1978 · S/N 282-78N5037CHakel Bruce A · Fairbanks, AKBuilt 1979 · S/N 1086-79N5037DC & R Leasing LLC · Fairbanks, AKBuilt 1958 · S/N 51137N5037EDevore James L · Carmichael, CABuilt 1958 · S/N 50337N5037KD & K Aviation Inc · Milford, IABuilt 1979 · S/N 1087-79N5037NTriniair LLC · Warner Robins, GABuilt 1979 · S/N 480-79N5037QSayler Ben · Thief River Falls, MNBuilt 1971 · S/N 340-0012N5037RJlinn Aviation Inc · Quinlan, TXBuilt 1974 · S/N 17263278N5037SGannon Gary L · Cumberland, WIS/N 28R-35781N5037TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250205N5037VPoh Enterprises LLC · Gardena, CABuilt 1975 · S/N 21060824N50389Sale Reported · Kissimmee, FLSale reportedBuilt 1979 · S/N 485-79N5038AWild River Flying Club · Saint Croix Falls, WIBuilt 1979 · S/N 376-79N5038EHohman Brent A · Fulton, SDBuilt 1979 · S/N 481-79N5038GStarros John P · Los Angeles, CAFirst renewal noticeBuilt 1979 · S/N 377-79N5038JKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 310R0158N5038KPiercy Ronald S · Moses Lake, WABuilt 1979 · S/N 482.79N5038LStopher Patrick K · Anchorage, AKS/N 495N5038PMidyett Charles O · Cambridge, MDBuilt 1958 · S/N 24-41
Back to AD 2007-04-19 R1