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.

N3938PSwoboda Matthias W · Green Bay, WIBuilt 1956 · S/N 22-3613N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038N3938WAugust Aero LLC · Kalispell, MTBuilt 1967 · S/N 32-887N3938ZCooper Donald A · Casper, WYBuilt 1962 · S/N 18-7784N3939DRed Baron LLC · Middletown, DEBuilt 1957 · S/N 34639N3939GThree Niner Gulf L L C · Denver, COBuilt 1967 · S/N U206-0939N3939KRegistration Pending · Grand Prairie, TXRegistration pendingBuilt 1967 · S/N 28-23814N3939RReid Edwin G Jr · Hollywood, MDBuilt 1970 · S/N 28-5850N3939TDespins David R · Gray, MES/N 28R-30281N3939XArapahoe Flight Club LLC · Colorado Springs, COBuilt 1975 · S/N 28-7515434N3939ZCarnine Daniel · Angora, NEBuilt 1962 · S/N 18-7785N393AWRoe Elton L · Harrison, ARBuilt 1968 · S/N 252N393BThickstun Benjamin Tyler · Wasilla, AKBuilt 1973 · S/N 18052299N393DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843851N393DMAlba Leasing Services LLC · Scottsdale, AZBuilt 2005 · S/N 10834N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261N393FBRegistered aircraftBuilt 2002 · S/N TH-2026N393HWilliams Fred V · Reno, NVBuilt 2022 · S/N 58P-111P/112P-P299N393KPBeyers Dale A · Walworth, WIBuilt 2004 · S/N 33010CN393LSBourne George L · Universal City, TXBuilt 2003 · S/N 81405N393MUsda Forest Service Fepp · Helena, MTBuilt 1964 · S/N 185-0684N393MAVandelay America LLC · Newport Beach, CABuilt 2007 · S/N 514-2007N393NMAce High Helos LLC · El Campo, TXBuilt 1999 · S/N 0706N393PSVein C Jason · Riviera Beach, FLBuilt 2005 · S/N 29-0393N393RCBarnes Thomas M · Pittsboro, NCBuilt 2001 · S/N 1176N393RVBell Paul E · Granbury, TXBuilt 2023 · S/N 92293N393TIronhawk Aviation LLC · Indianapolis, INBuilt 1963 · S/N D-7166N393TBTom Brown Consulting LLC · Ave Maria, FLBuilt 1969 · S/N 30-1874N393TCAnderson Kelvin W · Denver, COBuilt 2001 · S/N 1393N393THDobesh Craig L · Granbury, TXS/N 8N393TMAvion Acrobatico LLC · Waterloo, ILBuilt 1973 · S/N 82-73N3940KAir Ventures Flying School LLC · Smithfield, RIBuilt 1967 · S/N 28-23764N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388N3940QN3940q LLC · Newnan, GABuilt 1971 · S/N 17260040N3940ZGrasser Edward K · Palmer, AKBuilt 1963 · S/N 18-7786N3941DOrchid Aero LLC · Lakewood, COBuilt 1957 · S/N 34641N3941KHawkins Allan S · Lizella, GABuilt 1967 · S/N 28-23816N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042N3942TAuburn Valley LLC · Farmington, MNBuilt 1967 · S/N 28R-30285N3942WLarkin Jason · Zeeland, MIBuilt 1967 · S/N 32-931N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442N3942ZHigh Exposure Inc · Wilmington, DEBuilt 1962 · S/N 18-7867N3943Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1984 · S/N 17276186N3943DLoudan Christopher D · Trinidad, TXBuilt 1957 · S/N 34643N3943WCox Aviation LLC · Debord, KYBuilt 1967 · S/N 32-892N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443N3944FHenley Johnny · Trenton, NCBuilt 1976 · S/N 28-7615432N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819
Back to AD 2007-04-19 R1