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.

N375JSScharff John M · Clinton, ILBuilt 2000 · S/N 23645N375JTD2 Aviation LLC · Chesterfield, MOBuilt 1979 · S/N R18201291N375JWPanthers Aviation LLC · Pikeville, KYBuilt 1995 · S/N E-2918N375KSchlesinger Dmitri P · Los Angeles, CABuilt 2010 · S/N 530-2010N375KMSelchow Gene R · Machesney Park, ILBuilt 2009 · S/N 001N375LMiroyan Robert Trustee · San Jose, CABuilt 1973 · S/N E-427N375MASteinhardt Clark R Jr · Green Bay, WIBuilt 1999 · S/N 172S8077N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252N375PWRyan Adrian B · Anchorage, AKBuilt 1979 · S/N 18503965N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468N375RBMarinella Leasing LLC · Chandler, AZBuilt 1998 · S/N E-3155N375TJohnson Nick H · Houston, TXBuilt 2023 · S/N 1209-2023N375UMAlaskan Outhouse Adventures LLC · Big Lake, AKBuilt 1957 · S/N 18-5447N375WVictory Holdings LLC · Anacortes, WABuilt 1978 · S/N 18503598N375YVBisono Pablo R · San Juan, PRBuilt 1974 · S/N 17262930N3760BSavage David C · Austin, TXBuilt 1979 · S/N TC-2109N3760PAltitude Unlimited Inc · Lewes, DES/N 22-3483N3760TArizaga Diana M · Mamaroneck, NYBuilt 1967 · S/N 28R-30069N3760WTonini Ryan · Huntsville, ALS/N 32-677N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053N3761THupp Michael A · Marietta, OHBuilt 1967 · S/N 28R-30070N3761ZLazenby Gary M · Grangeville, IDBuilt 1960 · S/N 18-7523N3762NPost Timothy · Hillsdale, MIBuilt 1967 · S/N 680109N3762PMorrison Rodney R · Hot Springs, ARBuilt 1955 · S/N 22-3485N3762QHarris Randal Glenn · Sedona, AZS/N D-8398N3762TBenson Robert W · Iowa Park, TXBuilt 1967 · S/N 28R-30073N3762ZChapman Stuart M · Vernon, COBuilt 1960 · S/N 18-7525N3763FSmith Herbert L · Brandon, MSBuilt 1977 · S/N 0759N3763KRyback Andrew · Ocala, FLBuilt 1967 · S/N 28-23722N3763QOrr Robert · San Clemente, CABuilt 1967 · S/N D-8399N3763TGorey Chase · Saint Augustine, FLBuilt 1967 · S/N 28R-30074N3763UHunter James C · Shelton, WABuilt 1964 · S/N 18255163N3763WDaise Nicklaus J · West Chester, PABuilt 1966 · S/N 32-681N3764CCopeland Gary L · Williamsburg, MIBuilt 1980 · S/N 381N3764PValdes Omar F · Huntington Park, CABuilt 1955 · S/N 22-3488N3764ZDelph Timothy M · Wasilla, AKBuilt 1960 · S/N 18-7527N3765FSalton Robert L · Charlotte, NCBuilt 1977 · S/N 0760N3765QTonry Richard Martin · Georgetown, TXBuilt 1967 · S/N CE-139N3765SKennedy Patrick M · Great Barrington, MABuilt 1971 · S/N 17701629N3765THakanson Paul J · Norway, MEBuilt 1967 · S/N 28R-30076N3765WMazzochi James A · Hilton Head Island, SCBuilt 1966 · S/N 32-685N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265N3765ZKrumm Arno Hermann · Anchorage, AKBuilt 1960 · S/N 18-7528N3766DFree Range LLC · Missoula, MTS/N 34466N3766YPyanov Mark · Clinton, MSS/N 21058266N37674Bendure Ryan R · Brighton, COBuilt 1984 · S/N 516N3767PStrutzenberg Keith W Trustee · Chandler, AZBuilt 1955 · S/N 18-4645N3767TFd Equipment Rentals · Sacramento, CAS/N 28R-30078N37687Williams Lee E · Oshoto, WYBuilt 1999 · S/N 1
Back to AD 2007-04-19 R1