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.

N550CBCarnevale Philip A · Lake City, FLBuilt 1978 · S/N TE-1135N550CDCoen Scott D · Kingsport, TNBuilt 2004 · S/N 1124N550CERobinson James K · Eagle, IDBuilt 1975 · S/N 18264074N550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMBuilt 1973 · S/N D-9505N550DBHarding Mason · Phoenix, AZBuilt 1992 · S/N 539N550DDSaratoga Aviation LLC · Rocky Mount, NCBuilt 1996 · S/N 32-46037N550DEJanay Jesse A · Charlottesville, VABuilt 1998 · S/N 2656N550DFArrow Aircraft Leasing LLC · Tucson, AZBuilt 1978 · S/N TC-2197N550EEEidal Peter M · Kent, WABuilt 2014 · S/N 82123N550ERCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 172S10531N550FK38884 LLC · Moorhead, MNBuilt 1977 · S/N 18503229N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289N550GRClark Robert E · Meridian, MSBuilt 2001 · S/N 40015N550JAAlves Gerald T · Alamo, CABuilt 1962 · S/N TC-302N550JBBowley John P · Middletown, NYBuilt 1973 · S/N 18262671N550JEEssert Joe · Windsor, CORegistration expired, pending cancellationBuilt 1960 · S/N D-6356N550JKTaffet Jay · New Orleans, LABuilt 1986 · S/N 46-8608041N550JRUrban Cowboy Aviation LLC · Richland, NEBuilt 1990 · S/N CE-1449N550JSBawk Aviation LLC · Xenia, OHBuilt 1977 · S/N R18200105N550KBPradelt Charles · Queen Creek, AZBuilt 2001 · S/N ES-126-FBN550LAOscar Tango LLC · Mesa, AZBuilt 2017 · S/N 172S12045N550LEFlycarolina LLC · Concord, NCBuilt 1963 · S/N TC-400N550LMAdventure Day Aviation LLC · Greensboro, NCBuilt 1990 · S/N CE-1472N550LWWasserott Charles G · Owasso, OKBuilt 2001 · S/N ES 116N550MBRegistered aircraftBuilt 1964 · S/N D-7610N550MGGriggs Matthew J · Tunkhannock, PABuilt 1981 · S/N U20606173N550MHAviation Education Services Inc · Tetonia, IDS/N 11790-2N550NCTri-State Communications Inc · South Sioux City, NEBuilt 1988 · S/N CE-1241N550NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10992N550NVHoffman Andrew Todd · Mound House, NVBuilt 1973 · S/N 18262017N550PWhitmus Christopher A · Bowie, TXBuilt 2003 · S/N 3114N550PEHeller Ross S · Gig Harbor, WAS/N 550N550PJPeterson Todd · El Dorado, KSBuilt 1973 · S/N 18262142N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106N550RNovember Sierra Aviation LLC · Oneill, NES/N TC-391N550RESimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 21060968N550RGBr Ventures LLC · Port Orange, FLBuilt 2005 · S/N 1635N550RJHovermale Ken · Portland, MEBuilt 1989 · S/N E-2516N550RWNine Six Livestock Co · Sterling City, TXBuilt 1972 · S/N 18502015N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086N550UClear Sky Aviation LLC · Mccall, IDBuilt 1979 · S/N 18267182N550WHAlligator Inc · Lawrence, KSBuilt 1989 · S/N HAMSA/ROHDE0001N550WPJacobs Justin · San Francisco, CABuilt 1976 · S/N 18265163N550X550x LLC · Tucson, AZS/N D-9255N550YRFriedman Michael S · Chantilly, VABuilt 1981 · S/N TE-1196N550ZKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N U20604466N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851N5510MPatterson Philip Allen · Ailey, GABuilt 1967 · S/N 381N5510QN407ml LLC · Wilmington, DEBuilt 1965 · S/N 608
Back to AD 2007-04-19 R1