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.

N3530YScollon Brian F · Hudson, COFirst renewal noticeBuilt 1962 · S/N 18254430N3531Lippert Mark S · Collinsville, OKBuilt 1970 · S/N 198N35313Lyon W Bruce · Carterville, ILBuilt 1968 · S/N 17256706N35315Hubert Thomas D · Greenville, TXBuilt 1968 · S/N 17256708N35318Wings LLC · Scottsdale, AZBuilt 1968 · S/N 17256709N35319Yoder Electric Inc · Monticello, GABuilt 1978 · S/N 28-7816607N3531YPetter David · Stuttgart, ARBuilt 1962 · S/N 18254431N35321Manuel Greg R · Pecatonica, ILBuilt 1978 · S/N 28-7816606N35322Vincent Zachary T · Saint George, UTBuilt 1968 · S/N 17256710N35323Bourdon Greg · Henniker, NHBuilt 1968 · S/N 17256711N35324Schuster Darin D · New Castle, DEBuilt 1968 · S/N 17256712N35326Harrison Keith D · La Grange, NCBuilt 1968 · S/N 17256714N3532AGuedon Aviation LLC · Natchez, MSBuilt 1969 · S/N CE-289N3532EDubois William C · El Centro, CABuilt 1978 · S/N 17271576N3532LPiab Inc DBA · Fresno, CAS/N 18254932N3532NMoorefield Charles N · Houston, TXBuilt 1968 · S/N 680063N3532PBryan Curtis L · Enumclaw, WABuilt 1955 · S/N 22-3287N3532TNs Aviation Training And Rental Inc · Pembroke Pines, FLS/N 172S8820N3532XShipley James P · Los Alamos, NMBuilt 1966 · S/N 670069N3532ZMurphy Michael R Trustee · Syracuse, NYBuilt 1960 · S/N 22-7437N35330Wilkerson Jeffrey D · Morning Sun, IABuilt 1968 · S/N 17256715N35332Katchmar Michael L · Canon City, COBuilt 1968 · S/N 17256717N35337Myer Martin John Trustee · Juneau, AKBuilt 1968 · S/N 17256718N3533MBrowning Gregory S · Deputy, INBuilt 1978 · S/N 28-7890311N3533YFarley Sean D · Anchorage, AKBuilt 1962 · S/N 18254433N3533ZSchwanebeck Derek D · Ellsworth, NEBuilt 1960 · S/N 22-7438N35340Jones Donald E · Hollandale, MNBuilt 1968 · S/N 17256720N35344Sawyer James E · Urbana, OHBuilt 1968 · S/N 17256721N35345Flight One Holdings LLC · Devils Lake, NDBuilt 1968 · S/N 17256722N35348Jet & Rotor Aviation LLC · Sacramento, CABuilt 1968 · S/N 17256724N35349Stammich Thomas R · South Bend, INBuilt 1968 · S/N 17256725N3534FLackie Paul C · Melbourne, FLBuilt 1966 · S/N 18257534N3534HBeatty Don K · Mount Ulla, NCBuilt 1977 · S/N 22-1437N3534NCoffey Joseph · Camarillo, CABuilt 1967 · S/N 680087N3534QLeatherneck Aviation LLC · Billings, MTBuilt 1969 · S/N 188-0484N3534WSmittys Garage LLC · Fairmount, INBuilt 1966 · S/N 32-421N35358N44344 LLC · Wasilla, AKBuilt 1968 · S/N 17256732N3535QBoulton Stephen A · Eugene, ORBuilt 1973 · S/N 17261666N3535XZulu Aviation Corp · Fort Worth, TXBuilt 1966 · S/N 670072N35362Hicks James P · Franklin, OHBuilt 1968 · S/N 17256734N3536GGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 17281048N3536JSoronen Jack W · Berkeley Springs, WVBuilt 2000 · S/N 3365N3536NWestern Fires Inc · Yoncalla, ORBuilt 1967 · S/N 680088N3536XGreen William Robert Jr · Waller, TXBuilt 1966 · S/N 670073N35370Dans Land LLC · North Little Rock, ARBuilt 2001 · S/N T18208094N35371Honrud Joseph C · Cal Nev Ari, NVS/N 17256738N35377Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17256740N3537BDulles Aviation Inc · Bristow, VABuilt 2001 · S/N 172S8827N3537FWatson James L · Burke, VABuilt 1966 · S/N 18257537N3537JAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11614
Back to AD 2007-04-19 R1