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.

N28969Silva Carlos A · Massapequa, NYBuilt 1978 · S/N AA5B0911N2896EFlight Club 502 Inc · Louisville, KYBuilt 1978 · S/N 17271365N2896FEvans Gene · Center, MOBuilt 1966 · S/N 18256996N2896QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259896N2896RHuseman Adam · Clarinda, IABuilt 1969 · S/N 28R-35322N28973Coffman Joseph Bryan · North Pole, AKBuilt 1987 · S/N 1018N28976Kirby Benjamin · Colorado Springs, COBuilt 1978 · S/N AA5B0914N28978Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881280N28979Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881282N2897ASmiles Per Gallon LLC · Omaha, NEBuilt 1979 · S/N 28-7911230N2897FDeeck Mechanical Inc · Albemarle, NCBuilt 1966 · S/N 18256997N2897MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 28-7816323N2897RGervase Russell G · Farmington, NMBuilt 1967 · S/N 18258497N2897UWwe LLC · Ridgway, COBuilt 1987 · S/N 1017N2897WCasswell Paul H · Annapolis, MDS/N 28-7911234N2897YRegistered aircraftBuilt 1962 · S/N 18253897N28981Walker William B · Spokane, WABuilt 1978 · S/N AA5B0919N28983Radel Anne-Marie · West Hills, CABuilt 1978 · S/N AA5B0921N28986Recreation Plus Inc · London, OHBuilt 1978 · S/N AA5B0922N2898TR P M Flying Club Inc · South Holland, ILS/N 28-7225275N2898XOzment Dennis W · Palmyra, MOS/N 17700298N2898YKolling Aviation LLC · Spring Valley, MNS/N 18253898N289915 By 5 Aircraft LLC · New Braunfels, TXBuilt 1978 · S/N AA5B0926N28993Fradkin Tyler Jacob · Redondo Beach, CABuilt 1978 · S/N AA5B0927N28995Carlson Linda · Broomfield, COBuilt 1978 · S/N AA5B0929N28996H&A Aviation Lc · Hanover, VABuilt 1978 · S/N AA5B-0930N28998Clark Glenn W · Mary Esther, FLS/N AA5B0933N2899DPye Houston W · Cloudcroft, NMBuilt 1979 · S/N 32-7940192N2899FWashburn Michael D · Farmington, UTBuilt 1966 · S/N 18256999N2899GYoungpeter David L · Spencerville, OHBuilt 1968 · S/N 177N2899TLessley Aviation LLC · Winona, MSBuilt 1972 · S/N 28-7225276N289BBPeters Alan M · Arcola, TXBuilt 1996 · S/N 193N289BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881752N289CFWalker Dale Allan · Bakersfield, CABuilt 2007 · S/N 4240N289CLCripps Jason · Mcminnville, TNBuilt 2023 · S/N 18283241N289CRNiner Charlie Romeo LLC · Simpson, LABuilt 1974 · S/N 18263496N289CSChow Rogers LLC · Fort Myers, FLBuilt 2011 · S/N 18282289N289DMTros Corp · Wilmington, DEBuilt 1998 · S/N 401-98N289DSMidwest Avtech Inc · Peru, ILBuilt 2003 · S/N 40.289N289GBKh Aviation LLC · Forest City, NCBuilt 2005 · S/N 70400N289GRAerocomm LLC · Kalispell, MTBuilt 1959 · S/N 795N289HFLiegl Benjamin A · Fort Worth, TXBuilt 1977 · S/N AA5B0686N289HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842146N289HPLemon And Black LLC · Raleigh, NCBuilt 2003 · S/N 2843544N289JKFlightpath Aviation Services Inc · Brooksville, FLBuilt 1976 · S/N 17267701N289JMThibodeau Mark · East Falmouth, MABuilt 2015 · S/N 72489N289JSJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8996N289LASky Venture I Inc · Virginia Beach, VABuilt 2016 · S/N 13920N289MEWaseca Wings Inc · Owatonna, MNBuilt 1990 · S/N 243197N289PRWalker James E · Fuquay Varina, NCBuilt 1989 · S/N 5173
Back to AD 2007-04-19 R1