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.

N4977JJad Corp · Saint Cloud, MNBuilt 1968 · S/N 28R-30730N4977LApple Tree Aviation LLC · Gibsonia, PABuilt 1967 · S/N 28-4352N4977SMatheaus Michael · Sequin, TXBuilt 1970 · S/N 28R-35696N4977UBaker Bryan D · Anderson, CABuilt 1965 · S/N 21058677N4977YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4748N4978CRwr Air Inc · Tok, AKBuilt 1977 · S/N U20603870N4978DCanterbury James A · Dixon, ILBuilt 1958 · S/N 51078N4978FLabahn Ty L · Sherwood, ORBuilt 1966 · S/N U206-0678N4978GJin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273525N4978TRoth Robert A · Pacific Palisades, CABuilt 1981 · S/N R18201811N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180N4978VGeorgeson Troy D · Sheyenne, NDBuilt 1980 · S/N 172RG0442N4979ARothacker Aviation LLC · Chester Springs, PAS/N 32376N4979DTrissell Flying Service Inc · Clarksville, TXBuilt 1958 · S/N 51079N4979ESmith Corey C · Campton, NHBuilt 1984 · S/N 782N4979SDunn James J · San Ramon, CABuilt 1970 · S/N 28R-35698N4979VRobertson Roy E · Marion, IABuilt 1980 · S/N 172RG0443N497ABedell William F H · Church Hill, MDBuilt 1968 · S/N TE-547N497BWSwartz Taylor A · Fayetteville, NCBuilt 2014 · S/N 90762N497DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816567N497EBFl Scapes Inc · Panama City Beach, FLBuilt 1999 · S/N E-3296N497ERPlane Three Ltd · Wilmington, DEBuilt 1998 · S/N 17280673N497FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125314N497JSLindsey Steven W · Superior, COBuilt 2007 · S/N 81191N497LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020075N497LTRonneberg Dave H · Santa Monica, CABuilt 2010 · S/N L-002N497SJFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2000 · S/N 172S8497N497SUSouthern Utah University · Cedar City, UTBuilt 2006 · S/N 11441N497TBennett Howard M · Tullahoma, TNBuilt 1961 · S/N CD-324N497TCPinnacle Aviation Services Inc · Encinitas, CABuilt 2005 · S/N 172S9870N49809Anderson Erik G · Deerfield Beach, FLBuilt 1976 · S/N 14055N4980PLewis Clinton A · Antlers, OKBuilt 1963 · S/N 27-584N4980SGrenie Arles A · Richland Center, WIBuilt 1970 · S/N 28R-35699N4980TAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N R18201813N4980UUniveristy Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842229N4980ZElliott Charles · Rock Spring, GABuilt 1961 · S/N 22-8588N4981ALeseman Kelly · Anchorage, AKBuilt 1956 · S/N 32378N4981CWatson Michael · Dalhart, TXS/N 21063699N4981D23s Flyers LLC · Seeley Lake, MTBuilt 1958 · S/N 51081N4981EHendry Robert L · Lysite, WYBuilt 1982 · S/N 18268285N4981GGillespie John · Austin, TXBuilt 1979 · S/N 17273528N4981KCuriel Gabriel · Oakley, CAS/N P21000390N4981LBasinger Robert C · Freedom, PABuilt 1967 · S/N 28-4356N4981PTri State Aero Inc · Martinsburg, WVBuilt 1963 · S/N 27-585N4981SLacallle Darren M · Dover, TNBuilt 1970 · S/N 28R-35701N4981VWasatch Industries LLC · Ogden, UTS/N 172RG0444N4982DWeaver Dale · Macon, MSBuilt 1958 · S/N 51082N4982EDevrnja Aero LLC · Knoxville, TNBuilt 1978 · S/N 17271686N4982NReirdon Michael Shawn · El Cajon, CABuilt 1953 · S/N 53-4095N4983FSkyventure Avaition LLC · Battle Creek, MIS/N 17273115
Back to AD 2007-04-19 R1