Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1240GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1091 N1240JRinger Kevin L · Grants Pass, ORS/N 240 N1240MElk Creek Investments LLC · Helena, MTBuilt 1975 · S/N 18264255 N1240XPioneer Aviation LLC · Boise, IDBuilt 1963 · S/N 113 N12410Weiser Wings LLC · Houston, TXBuilt 1973 · S/N 17261978 N12419Fort Wayne Aircraft LLC · Fort Wayne, INBuilt 2006 · S/N 172S10306 N1241TGale Richmond T · Tewksbury, MABuilt 1972 · S/N 28-7225433 N1241UPensacola Navy Flying Club Inc · Pensacola, FLBuilt 1976 · S/N 17266936 N1241ZFeatherston Jacob Eric · Ferris, TXBuilt 1961 · S/N D-6701 N1242Aardvark Aviation LLC · Danvers, ILBuilt 2009 · S/N 91078 N1242BMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10307 N1242GHeathington A H · Georgetown, TXBuilt 1974 · S/N 310Q1093 N1242JLouisiana Aviation LLC · Marksville, LABuilt 1974 · S/N 242 N1242MHenninger Bradley J · Green Cove Springs, FLS/N 18264256 N1242NBg-Ip LLC · Saratoga, CABuilt 2006 · S/N 172S10309 N1242TDoblmaier Thomas J · North Wales, PABuilt 1972 · S/N 28-7205272 N1242UWingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17266937 N1242XCarpenter Charles P · Tarzana, CAS/N 115 N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002 N12439Vann Dudley C DBA · Greenville, NCBuilt 1973 · S/N 17261982 N1243MRegistered aircraftBuilt 1975 · S/N 18264257 N1243SDecatur Flight Center LLC · Decatur, TXBuilt 1970 · S/N 17259355 N12440Bill Myer Services Inc · Friday Harbor, WABuilt 1973 · S/N 17261983 N12441Jrm Wings LLC · Farmington, UTBuilt 1974 · S/N 17261984 N12442Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 17261985 N12445Old Style Aircraft LLC · Ellsinore, MOBuilt 1932 · S/N 3598 N12447Pickle Aviation LLC · Yakima, WABuilt 1973 · S/N 17261988 N12448Right Rudder LLC · Rexburg, IDBuilt 1973 · S/N 17261989 N1244APickard Martha Anne Gabriel · Hudson, OHBuilt 1957 · S/N 18-1037 N1244TMiddle Tennessee State University · Murfreesboro, TNBuilt 2015 · S/N 40.1191 N1244XLackey Lance Harold · New Braunfels, TXBuilt 1963 · S/N 117 N1244YBurbank Dennis · Arcadia, OKBuilt 1966 · S/N TE-253 N12452Cj Aviation LLC · Sonoma, CABuilt 1973 · S/N 17261992 N12456American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261994 N12459Circle S Aviation LLC · Starkville, MSBuilt 1973 · S/N 17261996 N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201 N1245BPositive Flight LLC · San Ramon, CABuilt 1975 · S/N 18264060 N1245SMccain Michael E · Sun Valley, NVBuilt 1976 · S/N 18264814 N1245UBello Carlos E · Lawrence, MAS/N 17266940 N12460Hollenshead Andrew P · Benton, LAS/N 17261997 N12464Bell Todd J · Joliet, MTFirst renewal noticeBuilt 1947 · S/N 12464 N12466Leaseair LLC · Wilmington, DEBuilt 1973 · S/N 17261999 N12468Sc Aviation LLC · Mooresville, NCBuilt 1973 · S/N 17262000 N12469Harrington Dara Voss F · Clyde Hill, WAS/N 17262001 N1246CTriplett Michael D · Eastsound, WAS/N 17702689 N1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingBuilt 1972 · S/N 32-7200034 N1246USnavely Clarella M · Coralville, IABuilt 1976 · S/N 17266941 N12470Pieper Ernest F · Artois, CABuilt 1973 · S/N 17262002 N12473Vero Technical Support Inc · Pensacola, FLBuilt 1973 · S/N 17262003 N12474Tail No N12474 LLC · Brewton, ALS/N 17262004

Back to AD 2007-04-19 R1