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.

N4673BRacoon Aviation LLC · San Antonio, TXBuilt 1955 · S/N 31571N4673FCody Richard A · Mclean, VABuilt 1966 · S/N P206-0273N4673NSimla Properties LLC · Casa Grande, AZBuilt 1979 · S/N 18266848N4673RBall Dontel J · Tacoma, WABuilt 1966 · S/N 28-21430N4673SGear Up Aviation LLC · Yukon, OKBuilt 1975 · S/N E-768N4673UStephl Chris L · Soldotna, AKBuilt 1964 · S/N 18051372N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466N4674EMilliken Bradley B · San Mateo, CABuilt 1982 · S/N 18268258N4674MPerpetual Rkm LLC · Kalispell, MTBuilt 1978 · S/N TC-2154N4674NBorderline Sky LLC · El Paso, TXBuilt 1980 · S/N 340A1023N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802N4675CLane Robert W · Palmer, AKBuilt 1974 · S/N 18502592N4675ERojo Aircraft LLC · Mesquite, NVBuilt 1982 · S/N 18268259N4675JRegistration Pending · Gardnerville, NVRegistration pendingBuilt 1968 · S/N 28R-30576N4675RLatham Cary · Hardin, KYBuilt 1966 · S/N 28-21432N46760Caterinichio Gasper D · Eagle River, AKBuilt 1954 · S/N 18-3907N4676BRobbins J Putnam · Valparaiso, INBuilt 1955 · S/N 31574N4676FSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7715059N4676PHuslig Brandon M · Carefree, AZBuilt 1960 · S/N 27-205N46775Lookner Augustus · Owls Head, MEBuilt 1954 · S/N 18-3594N4677DHorton Richard F · Los Lunas, NMBuilt 1957 · S/N D-4909N4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNBuilt 1978 · S/N 414A0068N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577N4677RFields Michael L · Rockwood, TNS/N 28-21434N4678AIflyjctc82 LLC · Macomb, ILBuilt 1970 · S/N E-229N4678BKing Paul E · Albany, ORBuilt 1955 · S/N 31576N4678DKennedy Kevin L · Moscow, IDBuilt 1956 · S/N D-4902N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278N4678KGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1975 · S/N 18263679N4678PRudloff Uwe K Trustee · Lake Village, INS/N 27-207N4678QPrairie Dog Aviation LLC · Sioux Falls, SDBuilt 1972 · S/N 21059578N4678RRegistration Pending · Vadnais Heights, MNRegistration pendingS/N 28-21436N4678TRothberg Diane Lee · Gainesville, GABuilt 1981 · S/N R18201730N4679AFlying Bulldogs LLC · Joplin, MOBuilt 1956 · S/N 32276N4679GFlightime Inc · Elkhart, INS/N 17273305N4679HAdams Kris · Griffin, GABuilt 1979 · S/N 24-0808N4679UNelson Ross R · Menomonie, WIBuilt 1964 · S/N 18051379N4679WBravo Whiskey LLC · Cascade, COBuilt 1978 · S/N 13255N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983N467AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843741N467AAWings Over Texas Holdings LLC · Denton, TXBuilt 2025 · S/N 353/USN467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879N467CDStarship 1 LLC · Houston, TXBuilt 2005 · S/N 1439N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859N467DBParamont Services Inc · Newbury Park, CABuilt 1978 · S/N 340A0467N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142N467DKRegistered aircraftBuilt 1995 · S/N 467
Back to AD 2007-04-19 R1