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.

N425SQSpinola Hernandes M · Homestead, FLS/N 23-1376N425TButler Joshua · Gravette, ARBuilt 1961 · S/N CD-281N425TASkyhawks Inc · Westminster, COBuilt 1976 · S/N 18264951N426Jarrett Franklin · Ivyland, PABuilt 1996 · S/N 1339N42604Lawrie Daniel A · Mesa, AZBuilt 1968 · S/N 18259100N42606Ramon Jose J · West Palm Beach, FLBuilt 1968 · S/N 18259101N42609Jcr Ag LLC · Frederick, OKBuilt 1980 · S/N 18803666N4260JSchroeder Gregory M · Saline, MIBuilt 1967 · S/N 28-22658N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160N42610Meadows Marcus · Anchorage, AKS/N 18052366N42615N42615 LLC · Shorewood, ILBuilt 1968 · S/N 18259107N4261CGidzinski David A · Weirsdale, FLBuilt 1954 · S/N E3B-329N4261EConger Jon W · Cottonwood Heights, UTBuilt 2000 · S/N 33001CN4261JMathison John M · Vancouver, WABuilt 1967 · S/N 28-22618N4262Regal Dent Inc · Goshen, NYFirst renewal noticeBuilt 2006 · S/N 2843647N42623Boulware Randall R Trustee · Bolivar, MOBuilt 1968 · S/N 18259110N42625Tull Matthew W · Niceville, FLBuilt 1968 · S/N 18259112N42627Henry Mark A · Dickinson, TXS/N 18259114N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105N4262HNorthern Iowa Anesthesia Services P L C · Ames, IAS/N 24-0688N4262JBeaverdam Aeronautics LLC · Chatom, ALS/N 28-22619N4262PPower Willis H · Weatherford, TXS/N 23-1761N4262SPeck Crosby S · Meredith, NHS/N E-942N42631Ga Elite LLC · Camarillo, CABuilt 1968 · S/N 18259115N42632Hebert Mark R Trustee · Lakeville, MNBuilt 2022 · S/N 18283184N4263HSchneider Michael J · Anchorage, AKBuilt 1948 · S/N 14-67N4263JBmf Wings LLC · Corinth, MSBuilt 1967 · S/N 28-22620N4263ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 18-8493N42645Williams Ray H Jr Trustee · Austin, NVBuilt 1968 · S/N 18259120N42647Glenwood Tank Facility LLC · Ramsey, MNBuilt 1968 · S/N 18259121N42648Propwash 182 LLC · Visalia, CABuilt 1968 · S/N 18259122N42649Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259123N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516N4264DKnisely Kevin R · Lapeer, MIBuilt 2000 · S/N 27002CN4264FNack Kim R · Wentzville, MOBuilt 1994 · S/N 1030N4264JBellamy Mark A · Freeville, NYBuilt 1975 · S/N 310R0201N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164N4264TSmith John W · Cold Spring, NJBuilt 1972 · S/N 28-7205124N4264ZAllen Steven L · Thatcher, AZBuilt 1967 · S/N 18-8507N42652West Dennis M · Lexington Park, MDBuilt 1968 · S/N 18259124N42653Stockwell William · Dowagiac, MIBuilt 1968 · S/N 18259125N42655Hawes Pamela M · Lancaster, MABuilt 1968 · S/N 18259126N4265HAngel Aviation Inc · Peoria, AZBuilt 1948 · S/N 14-69N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165N4265ZBaklarz Ralph B · Eagle River, AKBuilt 1967 · S/N 18-8508N4266Uber Robert Eric · Pittsburgh, PABuilt 1956 · S/N 38088N4266298x LLC · Caddo Mills, TXBuilt 1968 · S/N 18259128N4266BCarpenter Steven Warren · Inver Grove, MNBuilt 2000 · S/N 26009CN4266JMarvin Carlton R · Tomahawk, WIBuilt 1967 · S/N 28-22623
Back to AD 2007-04-19 R1