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.

N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1979 · S/N 17273359N4811JSeals Kenneth P · Munford, ALBuilt 1979 · S/N 17273681N4811NMiller Edwin C · Proctor, WVS/N 18267385N4811USwartz Ryan W · Pierre, SDBuilt 1963 · S/N 205-0511N4811YSale Reported · Dover, DESale reportedBuilt 1968 · S/N 25-4592N4812CRennekamp Eric J · Andersonville, TNBuilt 1981 · S/N 18268132N4812FNorth American Aerial Surveys LLC · Tucson, AZBuilt 1966 · S/N U206-0512N4812JJohnson Chris A · Fort Mohave, AZS/N 28R-30605N4812LPalmer Xavier · Moreno Valley, CABuilt 1967 · S/N 28-4151N4812SEdwards Daniel M · Wendell, NCS/N 32-1272N4812TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 28-7225211N4812UFoster Frank Brian · Goldsboro, NCS/N 205-0512N4812YRc Ag Air LLC · Cairo, MOS/N 25-4594N48130Estes Johnny C · Senoia, GABuilt 1976 · S/N 76N4813AVon Etten Robert P · Ravena, NYBuilt 1956 · S/N 22-3965N4813CCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276505N4813GBasso Michele · Millbrook, ALBuilt 1979 · S/N 17273361N4813LFitzgerald Timothy R · San Antonio, TXBuilt 1967 · S/N 28-4152N4813MCouch Walter J · Patterson, LABuilt 1978 · S/N E-1265N4813P4813p LLC · Newport, MEBuilt 1978 · S/N P21000115N4813SWescomp LLC · Kissimmee, FLBuilt 1969 · S/N 32-1273N4814Crawford Benjamin D · Anchorage, AKBuilt 1957 · S/N 32847N4814CKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275868N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366N4814LSingh Manjinder · Houston, TXS/N 28-4154N4814SRegistered aircraftBuilt 1970 · S/N 32-1274N4814TRobertson Roland L · Meridian, IDBuilt 1972 · S/N 28-7205199N4814UHash Marshall T · Inglis, FLBuilt 1963 · S/N 2050514N4814YKnerr Joshua D DBA · Tehachapi, CAS/N 25-4597N4815Ober John A · Candor, NYS/N 18053056N4815BCochise Community College · Douglas, AZBuilt 1955 · S/N 35115N4815CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276453N4815DBodeen Lance A · Eagle River, AKBuilt 1958 · S/N 34915N4815FAir 2 Sea LLC · Martin, TNBuilt 1976 · S/N 28-7715069N4815JRise Ronald B Jr · Purcellville, VABuilt 1966 · S/N CE-114N4815LSt Julian Randall R · Botkins, OHBuilt 1967 · S/N 28-4155N4815TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1972 · S/N 28-7205200N4815YAdrian Soaring Club Inc · Ypsilanti, MIBuilt 1968 · S/N 25-4567N4816ASullivan Phillip M · Louisville, KYS/N 22-3969N4816JMorten Derek J · Northwood, NDBuilt 1981 · S/N T18803768TN4816LGodfrey John E · Greensboro, NCBuilt 1967 · S/N 28-4156N4816RA&C Ag Aviation Inc · Unadilla, GABuilt 1975 · S/N 18802336TN4816SYarbrough Clay Alan · Brownsboro, ALBuilt 1970 · S/N 32-1276N4816TBulldog Air LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235114N4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388N4817DWirt James · Goldsby, OKBuilt 1958 · S/N 34917N4817TJoly Paul A · Henderson, NVBuilt 1972 · S/N 28R-7235115N4817YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4601N48187Nelson Lynn D · New Waverly, TXBuilt 1976 · S/N 26N4818ACampbell Allen G · Sault Sainte Marie, MIBuilt 1956 · S/N 22-3971
Back to AD 2007-04-19 R1