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.

N38357Carr Mark · Wshngtn Ct Hs, OHS/N 28-7790544N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671N3835THuber Charles H · Medina, OHBuilt 1967 · S/N 28R-30153N3835VJones Scott L · Hilliard, OHBuilt 1957 · S/N 18693N3835YCarlton Jeffery G · Great Falls, MTS/N 21058335N38368Dubisar Milo Richard · Redmond, ORBuilt 1977 · S/N 32R-7780419N3836CAdvanced Airways Inc · Loxahatchee, FLS/N 791N3836KValarchi Air Aviation LLC · Lewes, DEBuilt 1967 · S/N 28-23743N3836WOconnell Richard M · Dothan, ALBuilt 1966 · S/N 32-771N3836ZTroutman Charles W · Lincoln City, ORBuilt 1960 · S/N 18-7588N38373Outbound Aviation LLC · Dover, DEBuilt 1977 · S/N 28-7716247N3837DCameron Russell A · Fort Benton, MTBuilt 1957 · S/N 34537N3837EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960067N3837PPlancich Don A · Sterling, AKS/N 14-154N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937N3837TRemsberg Charles · University Place, WABuilt 1967 · S/N 28R-30155N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395N3837YRounds Chris · Waller, TXBuilt 1964 · S/N 21058337N3837ZTroutman Charles Wayne · Lincoln City, ORBuilt 1960 · S/N 18-7589N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091N38388Hosanna Industries Inc · Gibsonia, PABuilt 1977 · S/N 32R-7780422N3838GGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1967 · S/N U206-0838N3838PArlins Aircraft Service Inc · Belgrade, MTBuilt 1955 · S/N 22-3528N3838TFundamentals Aircraft Leasing LLC · Erie, PABuilt 1967 · S/N 28R-30157N3838XHolzman Douglas S · Hood River, ORBuilt 1966 · S/N 310K0238N3838ZWoldow Fredric A · Morton, ILBuilt 1960 · S/N 18-7592N38394Wall Jeffrey L · Goffstown, NHBuilt 1977 · S/N 28-7790548N3839DHot Rod Aviation LLC · Fayetteville, ARS/N 34539N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397N3839PMorris Equipment LLC · Yuma, AZBuilt 1955 · S/N 22-3529N3839RChad Gunter Enterprises LLC · Albany, GABuilt 1981 · S/N EA-199N3839SBailey Glenn K · Englewood, COBuilt 1981 · S/N EA-210N3839TN3839t LLC · Copley, OHS/N 28R-30158N3839XMigliaccio Vicki Trustee · Idabel, OKBuilt 1966 · S/N 310K0239N3839ZPrax Philip G · Fairbanks, AKFirst renewal noticeBuilt 1961 · S/N 18-7593N383BHAero Aircraft 13 LLC · Jacksonville, FLBuilt 1974 · S/N 17264151N383CCWiplinger Charles · Inver Grove, MNBuilt 2001 · S/N 9938CCN383DDawson Jamie S · Celina, TXBuilt 2007 · S/N 145N383DANew Mexico Flying Eagle Inc · Tucson, AZBuilt 2003 · S/N 2844098N383DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12648N383DFDream Flight LLC · Westminster, MDBuilt 1977 · S/N 17269914N383GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881118N383HRJirak Daniel L · Wasilla, AKBuilt 1985 · S/N 001N383KSchirmer Brandon M · Batesville, TXS/N 40771N383KDT-6 LLC · Wilmington, DEBuilt 2012 · S/N 18282358N383MAVandenberg Herbert F · Ruston, LAS/N 2048N383MEParlu Ventures LLC · Eagles Mere, PABuilt 2000 · S/N 172S8567N383MGMissionary Air Group · Burlington, NCBuilt 1982 · S/N U20606624N383NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881829N383PLambe Clarence Jr · Kernersville, NCBuilt 2001 · S/N E-3430
Back to AD 2007-04-19 R1