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.

N3QZTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 18261649N3RQAir Carriage Inc · Chico, CABuilt 1972 · S/N 523N3RTVitale James S · Port Orange, FLS/N 75TN3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442N3SGN3sg Enterprises Inc · Wilmington, DEBuilt 1960 · S/N 24-2036N3SHHill Stephen F · Frostproof, FLBuilt 1989 · S/N H-001N3SKMiller Chad L · Shipshewana, INBuilt 1979 · S/N AA5B1219N3SLMaedel John Henry Jr · Nesbit, MSBuilt 1968 · S/N 18259051N3SMQuaintance Christian N · Culpeper, VABuilt 1964 · S/N 18051488N3SUJenkins David G · Grantville, GABuilt 1965 · S/N TE-21N3SVYoung Karen Sue · Cincinnati, OHBuilt 1967 · S/N D-8426N3SYHigh Planes Aero Club Inc · Longmont, COBuilt 1967 · S/N 670016N3SZWiebens Peter M · Walnut Creek, CABuilt 1989 · S/N 1N3TFHelicopter Accessory Service East · Pensacola, FLS/N 34-0042N3THHayden Charles J III · Rhome, TXBuilt 1967 · S/N TC-1034N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547N3TQAbove Blue Line LLC · Austin, TXBuilt 1973 · S/N 310Q0752N3TYEvelyn Aviation Inc · Wilmington, DEBuilt 1975 · S/N TE-1065N3TZCasey Edmond L Trustee · Los Angeles, CABuilt 1968 · S/N 28R-30490N3UCYahraus Andrew · Phoenix, AZBuilt 1981 · S/N TJ-337N3UFAltorfer David W · Peoria, ILBuilt 1976 · S/N 21061410N3UGHoffman William C · Mount Pleasant, PABuilt 1977 · S/N 27-7854050N3UWRegistered aircraftBuilt 1964 · S/N 28-10341N3UXDiller Christina · Anchorage, AKBuilt 1979 · S/N 18267442N3VACook Marvin R · Portales, NMS/N 414-0258N3VBHarrison Ted W · Grapevine, TXBuilt 1965 · S/N 320D0044N3VCGreen John T Trustee · Kettering, OHBuilt 1980 · S/N R18201452N3VEAero 356 LLC · Phoenix, AZS/N 3073N3VGInverted Aero LLC · Spring Hill, FLBuilt 1991 · S/N 5198N3VJMiasnikowicz Victor · Lancaster, PABuilt 1973 · S/N 310Q0746N3VQOff The Ground LLC · Austin, TXS/N 34892N3VRMckinnon David C · Cornelia, GABuilt 1980 · S/N EE2N3VTFleming Stephen · Los Lunas, NMBuilt 1995 · S/N 21017N3VYSilverstein Adam R · Pittstown, NJBuilt 1957 · S/N BG-334N3VZHavard Mark · Groves, TXBuilt 1976 · S/N 18265132N3WDMorphew Ben · Mckinney, TXBuilt 1978 · S/N 01N3WFFolk Wolfgang · Fairfield, CABuilt 1975 · S/N 414-0617N3WJLlorca Carlo A · Naples, FLBuilt 1974 · S/N TC-1713N3WPHagar Kevin J · Skiatook, OKBuilt 1961 · S/N 1820N3XDHammer Steven L · Peachtree City, GABuilt 1996 · S/N 204N3XEServ Aero Engineering Inc · Salinas, CABuilt 1963 · S/N 30-92N3XHSmith Rodney S · Crawford, COBuilt 2024 · S/N 246N3XJJax Transport LLC · Amarillo, TXS/N 1390N3XKDriscoll David Delory Jr · Milwaukee, WIBuilt 1983 · S/N 002N3XMSmith Michael K · Grass Valley, CABuilt 1996 · S/N B93F96N3XSBrewer Joshua Ryan · Sonora, CABuilt 1996 · S/N C001N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156
Back to AD 2007-04-19 R1