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.

N4505YGeneral Air Service LLC · Van Wert, OHBuilt 1971 · S/N 18-8925N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811N4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTBuilt 1974 · S/N 18502576N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795N4506TPettit Kenneth W · Madison, INBuilt 1972 · S/N 28-7225176N4506VRegistered aircraftBuilt 1979 · S/N 28-8090026N45077Qualitair LLC Owner Trustee · MichelstadtBuilt 1978 · S/N 28-7911291N4507FRodriguez Kenneth C · East Wenatchee, WABuilt 1966 · S/N 185-0989N4507JSkvara Stanley Henry Jr · Parma, OHBuilt 1968 · S/N 28R-30363N4507NGarnet Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 28-8090031N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032N4507RFly First LLC · West Memphis, ARBuilt 1979 · S/N 28R-7918246N4507TLoma Aviation LLC · San Diego, CABuilt 1972 · S/N 28-7205174N4507XVanny Ravy · Winchester, CABuilt 1976 · S/N 28-7625046N4507YEmanuels Adam C · Selma, NCBuilt 1979 · S/N 28-7911290N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813N4508FStotz Jon · Rockford, MIBuilt 1966 · S/N 185-0990N4508JWood Daniel W · Cottonwood Shores, TXBuilt 1968 · S/N 28R-30364N4508RMcmichael Timothy J · Rock Hill, SCBuilt 1979 · S/N 32-7940245N4508XWestchester Flying Club Inc · Purchase, NYBuilt 1975 · S/N 28-7690026N4509BTrompeter Mark S · Intl Falls, MNBuilt 1955 · S/N 31408N4509HGolding Lee · Brookline, MOBuilt 1978 · S/N 24-0753N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741TN4509XPerformance Power Services Pc · Naperville, ILBuilt 1975 · S/N 28R-7635067N4509YWolfrum John A · Two Rivers, AKBuilt 1971 · S/N 18-8930N450AACentex Aero LLC Trustee · San Antonio, TXBuilt 2019 · S/N 2881256N450ASConroy Philip L · Colleyville, TXBuilt 1978 · S/N 27-7854123N450BASimmons Brian R · Heavener, OKBuilt 1981 · S/N M-2342N450CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881122N450CDAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N 1478N450CFZieger C Philip · Clearwater Beach, FLBuilt 1978 · S/N TC-2128N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214N450DHHewitt Rod · Federal Way, WAS/N 21057998N450DLBay Larry · San Diego, CABuilt 2003 · S/N 10236N450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12955N450FLMorriss Aviation LLC · Allen, TXBuilt 1971 · S/N 28-7125243N450JAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496150N450JDJd Dakota Leasing LLC · Stuart, FLBuilt 1978 · S/N 28-7911017N450JRNowell Borders Lp · Edinburg, TXBuilt 1975 · S/N TH-670N450JTN450jt LLC · Colleyville, TXBuilt 1981 · S/N 18268032N450KSGreene Tammy G · Alpharetta, GAS/N 1978N450LHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TC-2215N450MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 4496546N450PMStroede Scott E · King Salmon, AKBuilt 1958 · S/N 22-6206N450RBurns Richard · Wasilla, AKBuilt 2003 · S/N 450RN450RSMcpherson Norman B · Woodland Park, COBuilt 2009 · S/N 60425N450THHk Air LLC · Byron, GABuilt 1981 · S/N TH-1298N450TXM And M Aviation Leasing LLC · Wilmington, DEBuilt 2004 · S/N 1063
Back to AD 2007-04-19 R1