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.

N40042Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816004N40045Lawson William · Somerset, WIBuilt 1977 · S/N 28-7816006N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098N4004MAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2026 · S/N 2854N4004NBrunkenhoefer Travis L · Lewisville, TXBuilt 1968 · S/N 680018N4004TBennett John G · Melbourne, FLBuilt 1968 · S/N M-1110N4004ZTiffany David J · Lyme, CTBuilt 1963 · S/N 18-7955N40057Hovnanyan Ari · Van Nuys, CABuilt 1977 · S/N 28-7716313N40058Johnson Cassandra · Temecula, CABuilt 1977 · S/N 28-7816007N4005DHarris Mark P · Arcata, CABuilt 1957 · S/N 34705N4005ERmo Property Management LLC · Elkin, NCBuilt 1977 · S/N 18-7809016N4005YWareham Charles L · Chugiak, AKBuilt 1962 · S/N 185-0328N4005ZMills Air Service Inc · Marstons Mills, MABuilt 1963 · S/N 18-7956N40060Marshall Loraine · Independence, KYBuilt 1977 · S/N 28-7816009N40062Kiwi Air Inc · Sausalito, CAS/N 28-7890003N40068Van Houten Bradley Thomas · Naples, FLBuilt 1977 · S/N 28R-7737131N40069Brown Willard Jr · Far Hills, NJS/N 28-7890170N4006DTveitnes Svein T · Whitewright, TXBuilt 1957 · S/N 34706N4006MRegistration Pending · Wasilla, AKRegistration pendingBuilt 1947 · S/N 12-2883N4006VBaffin Resource Management LLC · Portland, TXBuilt 2025 · S/N 14918N4006ZGuisto Anthony Jl · Hood River, ORBuilt 1963 · S/N 18-7957N4007Empire Ranch Inc · Lebanon, MOFirst renewal noticeBuilt 1973 · S/N 18262208N40070Penski Christopher E · Ocala, FLBuilt 1977 · S/N 28-7816012N40079Atlantic Coast Helicopters Ltd · Ronkonkoma, NYBuilt 2025 · S/N 14869N4007ESimonson Gale J · Loring, MTBuilt 1977 · S/N 18-7809017N4007SBrennan Richard · Norfolk, VABuilt 2000 · S/N 18280682N4007TThurmond Paul J · Huntley, MTBuilt 1968 · S/N M-1114N4007XRobinson Helicopter Co · Torrance, CABuilt 2025 · S/N 14910N4007ZMcgeehan William F Jr Trustee · Marshfield, MOBuilt 1963 · S/N 18-7958N4008LBooth James L · Bozeman, MTS/N 0824N4008PViento LLC · Nashville, TNS/N 23-1483N4008VDelta Leasing Inc · Chandler, AZBuilt 2026 · S/N 14990N4009PApplegate Ronald E · Rosamond, CABuilt 1958 · S/N 23-1484N4009TLake Gary M · Edmond, OKBuilt 1968 · S/N M-1116N4009ZJackson R Sherer · Hayes, SDBuilt 1963 · S/N 18-7960N400ABFlydallasbay LLC · Soddy Daisy, TNFirst renewal noticeBuilt 1999 · S/N 838-99N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400BGMakarounis John C · Albuquerque, NMBuilt 1990 · S/N 01-BGN400BLBuilding Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1962 · S/N TC-319N400BMDufour William Anthony Jr · Bixby, OKBuilt 1991 · S/N 10038N400BTN Ranch LLC · Missoula, MTS/N R18200452N400CAGroundloop Mafia LLC · Desha, ARBuilt 1974 · S/N TC-1727N400CBSamper Aviation LLC · Easton, PABuilt 1969 · S/N 28R-31123N400CXCoker Steve L III · Tyler, TXBuilt 1967 · S/N 470N400DMAlborn Mary L · Eagle River, AKS/N E-748N400DPLindsey Russell R · Abilene, TXS/N 310R0268N400EDHotovec John W · Las Cruces, NMBuilt 1977 · S/N 570N400FLSouthard Joseph P · Greer, SCBuilt 1971 · S/N 28-7125174N400GBReed Daniel B · Salina, KSBuilt 1996 · S/N 573
Back to AD 2007-04-19 R1