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.

N4983GBrouillard Mark R · Avon, INBuilt 1979 · S/N 17273530N4983LDecoster Vaughn A · Greenwood, ARBuilt 1967 · S/N 28-4358N4983UEmerald Coast Entertainment LLC · Lewes, DEFirst renewal noticeBuilt 1984 · S/N 21064846N4983YCaprock Soaring Association · Lubbock, TXBuilt 1968 · S/N 25-4787N4984Hobschaidt Kurt J · Pittstown, NJBuilt 1955 · S/N JS-611N4984DDon Cat LLC · Shelby, MTS/N 51084N4984FChuprinko John A · Centerburg, OHBuilt 1977 · S/N 14246N4984JBluewater Airmotive Corp · Wilmington, DEBuilt 1968 · S/N 28R-30738N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137N4984PMoore Bruce W · Aledo, TXBuilt 1964 · S/N 27-588N4984RGingrich Fredric D II · Indianapolis, INBuilt 1977 · S/N 28-7890047N4984SLinair LLC · Lewes, DEBuilt 1970 · S/N 28R-35704N4984TBoggs Investments Air Div LLC · Fredericksburg, VABuilt 1972 · S/N 28-7225302N4985Crawford Loel H · La Follette, TNBuilt 1953 · S/N 34-125N4985JEri-Aero Land Partners LLC · Flower Mound, TXBuilt 1968 · S/N 28R-30739N4985TPope Donald R · Enid, OKBuilt 1972 · S/N 28R-7235167N4986DDodson Zachary S · Eastville, VAS/N 51086N4986FStanley Cherri · Pearland, TXS/N U206-0686N4986JMcelhiney Lance V · Harker Heights, TXBuilt 1968 · S/N 28R-30740N4986LFarrah Gabriel E · Avon, CTBuilt 1967 · S/N 28-4361N4986MLaney Construction Co Inc · Murphy, NCBuilt 1978 · S/N E-1282N4986PLms Aviation LLC · Omaha, NEBuilt 1964 · S/N 27-590N4987DKemp William L · Ellsworth, MIS/N 51087N4987JFulco Jason E · Frisco, TXS/N 28R-30742N4987NWhite Jake W · San Antonio, TXBuilt 1979 · S/N 2N4987PRegion Flyers LLC · Valparaiso, INBuilt 1964 · S/N 27-591N4988Marin Miguel A · QuebecBuilt 1979 · S/N P21000415N49886Boon Bradley A · Greenwood, WIBuilt 1962 · S/N 28-1010N4988FBielefeld James L · Kenai, AKBuilt 1966 · S/N U206-0688N4988LAnson Flyers Club Inc · Wadesboro, NCBuilt 1967 · S/N 28-4362N4988YVan Kleek Steve D · Milford, IABuilt 1968 · S/N 25-4797N4989DSwindle Jeffrey D · Lafayette, TNBuilt 1958 · S/N 51089N4989JEastern Florida State College · Cocoa, FLBuilt 1968 · S/N 28R-30744N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140N498CCShephard Russell Steven · Gallatin, TNBuilt 1976 · S/N 28R-7635447N498CDCrew Zen Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 1549N498CFBosely Thomas L · Tavernier, FLBuilt 1998 · S/N 5678N498CMRoberts Mark · Tecumseh, MIBuilt 2007 · S/N 82208N498DASmm Leasing LLC · Camp Verde, AZBuilt 1975 · S/N 310R0278N498ECEllie Belle Aviation LLC · Marietta, GABuilt 2013 · S/N 41240N498EKSpc Aviation LLC · Washington, DCBuilt 1966 · S/N 18257438N498EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11603N498HPSafe Flight Ops LLC · Venetia, PABuilt 1998 · S/N 3246121N498JBBriggs James D · Maryville, TNBuilt 2005 · S/N 90498N498LPN57kk LLC · Livingston, MTBuilt 2023 · S/N PX1520027N498MALake Air Express LLC · Bettendorf, IABuilt 1998 · S/N 3246098N498SPBmg Aviation Inc · Bloomington, INBuilt 1998 · S/N 172S8039N498TMagnolia Aviation LLC · Durant, OKBuilt 1961 · S/N CD-319N498THInterstellar Vc LLC · New York, NYBuilt 1978 · S/N AA5A0611N4990AHalunen Arlie J III · Seattle, WAS/N 32387
Back to AD 2007-04-19 R1