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.

N37CJFly172s LLC · Peoria, AZBuilt 1999 · S/N 172S8232N37CPRegistered aircraftBuilt 2012 · S/N 40795N37DAero Equities LLC · Ventura, CABuilt 1973 · S/N 570-73N37DKPreston Richard R Trustee · Albuquerque, NMBuilt 1978 · S/N GA7-0030N37DMWilliams Arzania S · Bolingbrook, ILBuilt 1968 · S/N 28-25245N37DNAshmore Seth S · Scottsboro, ALS/N 1030N37EFProctor John · Rosebud, TXS/N 31006N37EGVolterra LLC · Iowa City, IABuilt 2017 · S/N 14125N37ELLee Ed C · Lancaster, SCBuilt 2002 · S/N 90361N37EWKundel Andrew R · Muscatine, IAS/N U20602997N37EZCaulkins John · Bay Village, OHBuilt 2003 · S/N 2198LN37FLN37fl LLC · Port Saint Lucie, FLBuilt 2020 · S/N 41658N37GWillamette Valley Soaring Club · Beaverton, ORBuilt 1966 · S/N 188-0166N37GGAvco Patrol LLC · Lyndon, KSBuilt 1999 · S/N 18280353N37GMCraft Engineering Associates Inc · Hampton, VABuilt 1979 · S/N 340A0684N37GWSale Reported · Webster, MNSale reportedBuilt 2017 · S/N 50N37HDJohnston-Matejek Aviation LLC · Houston, TXBuilt 2006 · S/N 18281850N37HMRegistration Pending · West End, NCRegistration pendingBuilt 1981 · S/N TRGR-1N37HYRegistration Pending · Wasilla, AKRegistration pendingBuilt 1999 · S/N 2037N37JJMamuzich Robert J Jr · Ocala, FLBuilt 1987 · S/N 1243N37JNWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1997 · S/N 5373N37JSNewton Wm L · China Spring, TXBuilt 1959 · S/N 51915N37KBMccraw Michael · Myakka City, FLBuilt 1966 · S/N D-8046N37KFFillips Karl · Alvin, TXS/N 317-77N37LMMay Richard A · Fort Mill, SCBuilt 1971 · S/N 170N37LVLegros Aviation Services Inc · Crowley, LABuilt 1992 · S/N 695-92N37MAAndorfer Micheal T · Fort Valley, GABuilt 2021 · S/N 73542N37MCTvb Aviation LLC · Mcallen, TXBuilt 1988 · S/N CE-1258N37MFMueller Martin S · Coeur D Alene, IDS/N FREEMAN S T #1N37MGWood Ronald G · Weatherford, TXBuilt 1997 · S/N 29-0110N37MJLara-Meza Sergio Giovanni · Mcallen, TXS/N P21000552N37MKSkyhoundmedia Inc · Royal Oak, MIBuilt 1970 · S/N D-9168N37MLLacher Meldon J · El Cajon, CABuilt 1999 · S/N 001N37MTBeaver Valley Flying Club Inc · Beaver Falls, PABuilt 1999 · S/N 172S8205N37MVMonreal Michael · North Barrington, ILBuilt 1969 · S/N 32-40657N37MZHamm George W Trustee · Fort Worth, TXBuilt 2013 · S/N 70628N37NCGlace Charles L · Spartanburg, SCBuilt 2010 · S/N 1079N37NERotor Technologies Inc · Nashua, NHBuilt 1994 · S/N 2450N37NHLfs Inc · Ekalaka, MTFirst renewal noticeBuilt 2008 · S/N 3028N37PVan De Pol John M · Amherst, TXS/N 21564N37PAThree Rivers Aero LLC · Three Rivers, MIS/N TC-1267N37PB37pb Inc · Seattle, WABuilt 1972 · S/N 21059737N37PKThill James L · Leesburg, VABuilt 2001 · S/N 80890N37PMRegistered aircraftBuilt 1985 · S/N 46-8508058N37PRS & R Planes LLC · Tulsa, OKBuilt 1950 · S/N 18-90N37RAGustafson John A Trustee · Boulder City, NVBuilt 2001 · S/N E-3422N37RCCorrao Robert F Jr · Scottsdale, AZBuilt 1995 · S/N E-2986N37RFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1977 · S/N 18503447N37RHRegistered aircraftBuilt 1995 · S/N 22585N37RKWardrop Donald Alexander · Bay Springs, MSBuilt 1985 · S/N 482
Back to AD 2007-04-19 R1