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.

N41477Shepro Scott M · Senoia, GABuilt 1974 · S/N 28-7405107N4147BBaughman David W · Tijeras, NMFirst renewal noticeBuilt 1976 · S/N 76-31128N4147EEnglerth Mark J · Wasilla, AKBuilt 1978 · S/N 18-7809086N4147GStinson Aaron M · Anchorage, AKFirst renewal noticeBuilt 2000 · S/N 28-43364N4147KUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843169N4147NGeorge Robert J · Natick, MABuilt 1999 · S/N 3246131N4147SDrew Danny Paul · Broken Arrow, OKBuilt 1975 · S/N CE-565N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272N4147YReisdorf Steven R · Saint Cloud, MNBuilt 1976 · S/N 956-76N4147ZHopper Bruce · Chugiak, AKBuilt 1965 · S/N 18-8225N41480Tradewind Aviation Co Inc · Blue Bell, PABuilt 1999 · S/N 3246147N41482Cannella Ingrid D · Pineville, LABuilt 1974 · S/N 28-7415231N41484Ferraro Jeffrey T · Mckinney, TXBuilt 1999 · S/N 4636234N4148CMjolhus Knut G · Amarillo, TXBuilt 1978 · S/N R18200329N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170N4148EDoody Michael C · Knoxville, TNBuilt 1978 · S/N 18-7809087N4148GKutrieb Wolfgang Michael · Chetek, WIBuilt 1977 · S/N 340A0318N4148HRegistered aircraftBuilt 1978 · S/N 24-0647N4148QRomeo Carmen J · Beaver, PABuilt 1968 · S/N 310N-0048N4148TChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496027N4148UFlightline Helicopters Inc · Cave Creek, AZFirst renewal noticeBuilt 2008 · S/N 4290N4148WMirarchi Joseph F · New Braunfels, TXBuilt 1973 · S/N TC-1561N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76N4148ZWillet Gerald E · Townsend, MTBuilt 1965 · S/N 18-8227N41497Bagley Russell L · Frankston, TXBuilt 1974 · S/N 28-7425249N41498G&M Aircraft Inc · Wheat Ridge, COBuilt 1974 · S/N 28-7415237N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190N4149DLangley Richard · Sheyenne, NDBuilt 2008 · S/N 12184N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191N4149JElko Aviation Group LLC · Elko, NVBuilt 1966 · S/N 28-22474N4149QMustain Michael J · Monticello, GABuilt 1968 · S/N 310N-0049N4149SDelgado Dimitri Antonio · Tampa, FLBuilt 1975 · S/N D-9745N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192N4149XCyclic LLC · Kalispell, MTBuilt 2008 · S/N 12186N414ACBirman Pablo · Suamico, WIBuilt 1975 · S/N 414-0820N414AFSano Aviation Corp · Lewes, DEBuilt 1971 · S/N 414-0167N414AKValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A0321N414AMToucan Aviation LLC · Lafayette, LABuilt 1982 · S/N 414A0850N414AQQualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 414-0472N414ARFlight Med LLC · Cumming, GABuilt 1976 · S/N 4140902N414ASRobertson Julianne · Los Osos, CABuilt 1991 · S/N EA-523N414ATCreekmore Arnold · Somerset, KYBuilt 1978 · S/N 414A0209N414AWAlycone Trust Corp Trustee · Wichita, KSS/N 4140520N414BAOptimal Health Systems LLC · Pima, AZBuilt 1970 · S/N 414-0047N414BCRoche Robert C · Casa Grande, AZBuilt 1965 · S/N 28-21129N414BDBostater Charles Jr · Indn Hbr Bch, FLBuilt 1973 · S/N 414-0430N414BGGreen Forest Aviation LLC · Edmond, OKBuilt 1978 · S/N 414A0094N414BH414bh LLC · Laramie, WYBuilt 1997 · S/N LIV-211N414BLBig South Fork Aero Inc · Huntsville, TNBuilt 1978 · S/N 414A0115
Back to AD 2007-04-19 R1