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.

N55MBSimon Caesar · Carmel, CABuilt 1978 · S/N 18266750N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103N55MJBarodge Equipment Leasing Inc · Fairmount, INBuilt 1980 · S/N 32R-8013068N55MLAlmeida Gabriel · Bellville, TXBuilt 1964 · S/N TC-691N55MRQc Executive Aviation LLC · Sheridan, WYBuilt 1974 · S/N 18262983N55NABloomhardt Theodore E · Hinesburg, VTBuilt 1974 · S/N 18262915N55NDMeyer William M · Chicago, ILBuilt 1976 · S/N 606HN55NLExtra Air LLC · Port Orange, FLBuilt 2000 · S/N 112N55NPN55np LLC · Broomfield, COS/N 700010N55NSBrown Nelson S · Auburn, WABuilt 1955 · S/N 31469N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184N55PFBurris Adam Eugene · Graham, WABuilt 1966 · S/N 18257888N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55PKGlasheen Sean T · Bethel, AKBuilt 2019 · S/N CC18-0096N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55PPChaffey Community College District · Rancho Cucamonga, CABuilt 1972 · S/N 414-0366N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675N55PVHeli Munnik LLC · Springfield, MOBuilt 2005 · S/N 10815N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CCN55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015N55RCSmith Matthew E · Creston, IABuilt 1989 · S/N 288N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307N55RHMccarthy Michael E · Martinez, CABuilt 1969 · S/N P206-0584N55RKSaunders Christopher D · Lehighton, PABuilt 1998 · S/N TD 2020N55RSCrop-Serv Inc · Meade, KSBuilt 1966 · S/N TE-151N55RVRegistration Pending · Dover, DERegistration pendingBuilt 1975 · S/N TC-1828N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586N55RYTwenty Nine Ninety Two LLC · Edina, MNBuilt 2015 · S/N 18282371N55STriple R Aviation LLC · Cleburne, TXBuilt 1965 · S/N TD-631N55SEN55se LLC · Frankfort, ILBuilt 1968 · S/N TC-1136N55SFRegistered aircraftBuilt 1979 · S/N R18201016N55SGBas Part Sales LLC · Greeley, COBuilt 1976 · S/N TC-1955N55SHTiedeman Craig L · Seven Bays, WABuilt 1998 · S/N 55-483103N55SJBk Air LLC · New Brighton, MNBuilt 1982 · S/N TC-2447N55SNHussey Arthur M III · Fairbanks, AKBuilt 1964 · S/N 18255199N55SPJ&D Flying LLC · Clinton, MOBuilt 1966 · S/N D-8084N55TBKennedy Michael Allen · Oxnard, CABuilt 1966 · S/N 28-21634N55TEMaxwell Aviation Inc · Chesterfield, MOFirst renewal noticeBuilt 1975 · S/N TC-1832N55TGPrzyborowski James J · Colchester, CTBuilt 1981 · S/N 7375CN55TLRegistered aircraftBuilt 1976 · S/N TE-1079N55TMThomas Kurtis · Lubbock, TXBuilt 1978 · S/N TH-901N55TPMyers Dwayne L · Newcastle, WABuilt 2006 · S/N 11464N55TSFlying Monkey LLC · Wilmington, DEBuilt 1961 · S/N TC-146N55TWBeyer Arthur J · Cheektowaga, NYBuilt 1976 · S/N 248N55TXSan Diego Air & Space Museum · San Diego, CABuilt 1986 · S/N 551N55TZBoswell Rick · Bartlesville, OKBuilt 1977 · S/N TE-1115N55UBEuroaviation Inc Trustee · KematenBuilt 1956 · S/N 18-4264N55VAHoward Alan L · Leeds, UTBuilt 1957 · S/N D-4996N55VFTjp Aviation Inc · Garrettsville, OHBuilt 1978 · S/N TC-2132N55VGA And E Aero Ventures LLC · Saline, MIBuilt 1978 · S/N TC-2165
Back to AD 2007-04-19 R1