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.

N455QSouthern Utah University · Cedar City, UTBuilt 1972 · S/N TC-1441N455RBGh Enterprises Inc · Baton Rouge, LABuilt 1977 · S/N TE-1099N455RTSouthern Genesis Aero LLC · Midland City, ALBuilt 2000 · S/N 447-2000N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N455TASurles Gregory Taylor · Emerald Isle, NCBuilt 1978 · S/N AA5B-0571N455TBSmith Loren D · Great Falls, MTS/N 310R1860N4560KRegistered aircraftBuilt 1948 · S/N NAV-4-1560N4560MPhillips William S · Normandy Park, WAFirst renewal noticeBuilt 1978 · S/N CE-770N4560PAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1960 · S/N 27-66N4560YCleveland William B III · Canal Fulton, OHBuilt 1973 · S/N 18-7309017N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052N4561XAir Bhnb LLC · Statesboro, GAS/N 28-7625055N4562FMcdaniel Dean K · Queen Creek, AZS/N 185-1069N4562MBbt Aviation LLC · Rapid City, SDBuilt 1978 · S/N E-1237N4562RMcclure Richard A · Victoria, TXS/N 28-21304N4562TSellers Kelly A · Crossville, TNS/N 28-7205186N4562XVenture West LLC · Mesa, AZBuilt 1975 · S/N 28R-7635078N4562YEd Air Inc · Oaktown, INBuilt 1967 · S/N 25-4186N4563BLarose Gary R · Anchorage, AKS/N 31462N4563JPilling Ian M · Bonita, CABuilt 1968 · S/N 28R-30425N4563SMeyerhoff Scott G Trustee · Reno, NVBuilt 1975 · S/N CE-604N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N4563WE&V Air LLC · Chatsworth, GABuilt 1973 · S/N 18262363N4564FStern Aviation Inc · N Fort Myers, FLBuilt 1976 · S/N 28R-7635454N4565AGriswold Joshua M · Wasilla, AKBuilt 1956 · S/N 22-3876N4565FHughey Charles A Jr · Oak Ridge, TNBuilt 1976 · S/N 28-7725022N4565RHenderson Javier · Raleigh, NCS/N 28-21308N4565SGl Aviation LLC · Mcmurray, PABuilt 1975 · S/N E-736N4565TSchendel Daryl R · Barstow, CABuilt 1972 · S/N 28R-7235094N4566BWagnon Bertram L · Anchorage, AKS/N 31465N4566JDifilippo Antonio O · Spring Church, PABuilt 1968 · S/N 28R-30429N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4566RMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-21309N4566SWalters G David · Sarasota, FLBuilt 1975 · S/N D-9804N4566WBoling Kyle C · Oak Hill, FLBuilt 1976 · S/N 13056N4566XZihala William · North Little Rock, ARBuilt 1975 · S/N 28R-7635079N4567Amigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11033N45678Kdm Aviation LLC · Wilmington, DEBuilt 2012 · S/N 41063N4567ADonovan Timothy P · Wichita Falls, TXBuilt 1956 · S/N 22-3878N4567BCavu LLC · Boise, IDBuilt 1955 · S/N 31466N4567FPatterson Roland O · Semmes, ALBuilt 1960 · S/N 57314N4567TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250136N4568ABartlett Michael W · Barron, WIBuilt 1956 · S/N 22-3879N4568CYorde Roger C · North Fort Myers, FLBuilt 1963 · S/N 21058142N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549N4568RChuss Edward J · Metamora, MIBuilt 1965 · S/N 28-21326N4568SYuma Desert Fliers LLC · Yuma, AZFirst renewal noticeBuilt 1975 · S/N CE-605N4569CReese Brandon A · Bend, ORS/N 25423N4569HPowell Randy N Trustee · Elko, NVBuilt 1979 · S/N 24-0849N4569RNoco Flying Club LLC · Fort Collins, COBuilt 1966 · S/N 28-21310
Back to AD 2007-04-19 R1